{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","GP Exp","MC Exp","Site Control 2","Site Control 3","Site Control 4","Site Control 5","LSQ","Zoning","Syndication","Impact Fees","Architect","Accessibility","Farmworker","Data","Lists"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":75,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":153,"n_cols":18,"rows_kept":153,"cut":false,"hidden":false,"merged":[[8,16,8,21],[47,2,50,11],[140,14,140,16],[142,2,143,11],[145,1,145,11],[82,2,84,11],[86,2,90,11],[136,2,138,11],[0,0,0,12],[106,1,106,11],[94,1,94,11],[98,2,102,11],[103,2,104,11],[3,1,3,11],[42,4,42,9],[35,2,36,11],[91,2,92,11],[44,2,45,11],[5,1,8,11],[80,1,80,11],[9,4,9,8],[96,2,97,11],[150,1,150,11],[152,2,153,11],[140,1,140,11],[1,4,1,8],[120,1,120,11],[124,2,125,11],[129,1,129,11],[133,2,134,11],[113,2,114,11],[116,1,116,11],[108,2,110,11],[111,2,111,11],[63,2,65,11],[131,2,131,11],[40,2,40,11],[147,2,148,11]]}
["Instructions"]
[null,null,null,null,"Version 3.3"]
[]
[null,"Linking to your E-application"]
[]
[null,"This workbook is linked to and dependent upon the current CTCAC 9% e-application or Attachment 40. This is intended to reduce duplicate data entry and perform calculations for applicants. Only a limited amount of data is required for this workbook to populate. Please see the list to the right. \nWe greatly value your feedback and suggestions for improving the application process. Please send your thoughts to TCACdocs@treasurer.ca.gov with the subject “Linked Workbook Feedback”."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required Data to Populate Exhibit B"]
[null,null,null,null,{"$f":"HYPERLINK(\"mailto:tcacdocs@treasurer.ca.gov?subject=Linked Workbook Feedback\",\"mailto: TCACdocs@treasurer.ca.gov\")","v":"mailto: TCACdocs@treasurer.ca.gov"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Project Name"]
[null,"1)","You must be on the Instructions tab to point this workbook to your e-application.",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Housing Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Applicant Info"]
[null,"2)","Select the “Workbook Links” icon within the “Data” menu in the ribbon above ([Alt + A] then [Alt + K]).",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","General Partner Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Developer Info"]
[null,"3)","On the right side of your workbook, the Workbook Links side bar will appear.",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Management Company Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Site Info (Address, City, County, Census Tract)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Total Unit Count (not Unit Mix)"]
[]
[]
[]
[]
[]
[]
[]
[null,"4)","Select \"...\" to the right of the linked file. Select \"Change source\" from the dropdown."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5)","In the Change Source dialogue box, navigate to and select your e-application then click the “Open” button. Note: many calculations within this workbook will not work properly until the e-application is complete."]
[]
[]
[null,"6)","After the linked cells have updated, “Close” the Workbook Links side bar."]
[]
[null,"7)","If the links were successfully updated, your project name should appear below. "]
[]
[null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[null,"8)","Cells with grey backgrounds are pulled from (or based on data from) your e-application. Applicants should only provide information in cells with yellow backgrounds. All sheets in this workbook are intended to be completed, printed or PDF'd, and signed physically or digitally to be submitted in PDF form with your application."]
[]
[]
[null,"9)","While working with linked workbooks you may be prompted with one of the following warnings. You will be required to “Enable Content” or “Update” linked cells to keep the workbooks in sync. When you make changes to the e-application you should open, update linked cells, and save all other linked workbooks. It is the applicant’s responsibility to ensure all information provided is consistent."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10)","If you move or rename the e-application or its folder, you may be notified that linked cells can’t be updated. While on the Instructions tab, you should be able to “Edit Links” and “Change Source” to communicate the correct file path."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"GP (General Partner) Exp tab"]
[]
[null,"1)","Select the name for the General Partner requesting points. For Tribal Applicants only, select the Developer entity. Select \"TRUE\" if requesting points for special needs through Nonprofit or Special Needs set-aside, or select \"TRUE\" for Tribal Applicants. Make sure to enter the correct application deadline."]
[]
[]
[]
[null,"2)","Enter Project Name and Address. Enter a project ID number (typically a CTCAC number, but not always). Select \"TRUE\" if a CTCAC project. Enter the number of Low Income Units. Select \"TRUE\" if a Special Needs Project. Enter the number of Special Needs Unit if applicable. Enter the Date Placed in Service, Date GP Participation Began, and Date GP Participation Ended if applicable. The sheet will calculate the full number of years managed."]
[]
[]
[]
[]
[null,"3)","Once completed, either print physically or to PDF and have the form signed physically or digitally by a Principal of the General Partner, or Developer Entity and Tribal Applicant, named therein."]
[]
[]
[null,"MC (Management Company) Exp tab"]
[]
[null,"1)","Select the name for the Management Company name requesting points. Select \"TRUE\" if requesting points for special needs through Nonprofit or Special Needs set-aside."]
[]
[null,"2)","Enter Project Name and Address. Enter a project ID number (typically a CTCAC number, but not always). Select \"TRUE\" if a CTCAC project. Enter the number of Low Income Units. Select \"TRUE\" if a Special Needs Project. Enter the number of Special Needs Unit if applicable. Enter the Date Placed in Service, Date Management Began, and Date Management Ended, if applicable. The sheet will calculate the full number of years managed."]
[]
[]
[]
[]
[null,"3)","Once completed, either print physically or to PDF and have the form signed physically or digitally by a Principal of the Management Company named therein."]
[]
[]
[null,"LSQ (Legal Status Questionnaire) tab"]
[]
[null,"1)","This tab contains a Legal Status Questionnaires for each relevant member of the development team - Applicant, Developer, and up to 3 General Partners as listed in the application."]
[]
[]
[null,"2)","Select either \"Nothing to Disclose\" or \"Disclosure provided in tab 5.\""]
[]
[null,"3)","If you selected \"Disclosure provided in tab 5\" for any member of the team, please provide the disclosure in tab 5 and include a cover page or header indicating  the company or individual it is for."]
[]
[]
[null,"Zoning tab"]
[]
[null,"1)","The Zoning tab should be completed by an agent of the City or County in which the project is to be located."]
[]
[null,"Syndication tab"]
[]
[null,"1)","Enter the amount of credits requested for allocation and the estimated gross proceeds."]
[]
[null,"2)","Enter all expenses, specifying what they are if using the \"Other\" rows. Total expenses and net equity will be calculated for you."]
[]
[]
[null,"3)","The Syndication tab should be signed by an agent of the investor named as an interested party."]
[]
[null,"Impact Fees tab"]
[]
[null,"1)","You may duplicate this tab if you have multiple assessing entities that are responsible for different impact fees."]
[]
[null,"2)","To do so, right-click the tab and select \"Move or Copy...\", highlight \"Architect\", and check \"Create a copy\" before selecting \"Okay\"."]
[]
[]
[null,"3)","The Impact Fees tab should be signed by an agent of the assessing entity. If the assessing entity does not complete \"Impact Fees\" tab, then the applicant must provide a completed copy of this tab along with other evidence from the assessing entity, such as current fee schedules."]
[]
[]
[]
[null,"Architect tab"]
[]
[null,"1)","The Architect tab should be completed by the project's architect. The items checked should match any threshold basis limit increases requested in your e-application."]
[]
[]
[null,"Accessibility tab"]
[]
[null,"1)","If requesting points under Reg. § 10325(c)(8)(B), the Accessibility tab should be completed by the project's architect."]
[]
[]
[null,"Farmworker tab"]
[]
[null,"1)","If a State Farmworker Credit project, the Farmworker tab should be signed by the applicant."]

{"sheet":"GP Exp","index":1,"n_rows":46,"n_cols":66,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,17,10,19],[10,1,10,12],[11,1,11,12],[14,13,14,16],[0,55,9,55],[13,13,13,16],[9,17,9,19],[11,17,11,19],[3,31,3,33],[12,44,12,48],[13,44,13,48],[10,39,10,43],[10,29,10,33],[10,34,10,38],[3,43,3,48],[4,26,4,30],[0,56,9,56],[12,17,12,19],[13,17,13,19],[0,52,9,52],[0,53,9,53],[0,54,9,54],[3,8,4,23],[10,20,10,22],[9,20,9,22],[11,20,11,22],[9,26,9,28],[10,26,10,28],[10,13,10,16],[9,13,9,16],[11,13,11,16],[12,13,12,16],[6,61,9,61],[9,44,9,48],[10,44,10,48],[11,44,11,48],[6,59,9,59],[6,60,9,60],[0,57,9,57],[0,50,9,50],[0,51,9,51],[0,0,0,48],[7,1,7,2],[6,3,7,35],[6,46,6,48],[9,39,9,43],[9,29,9,33],[9,23,9,25],[9,34,9,38],[13,26,13,28],[11,29,11,33],[12,29,12,33],[13,29,13,33],[11,26,11,28],[14,29,14,33],[11,34,11,38],[12,34,12,38],[15,50,15,52],[29,9,30,24],[14,34,14,38],[13,23,13,25],[14,23,14,25],[16,50,16,52],[17,50,17,52],[18,50,18,52],[14,1,14,12],[11,23,11,25],[6,58,9,58],[25,1,28,43],[25,44,25,48],[14,17,14,19],[12,20,12,22],[13,20,13,22],[14,20,14,22],[12,26,12,28],[12,23,12,25],[10,23,10,25],[9,1,9,12],[12,1,12,12],[13,1,13,12],[19,50,19,52],[14,26,14,28],[13,34,13,38],[7,46,7,48],[11,39,11,43],[12,39,12,43],[13,39,13,43],[14,39,14,43],[14,44,14,48],[42,9,42,24],[45,9,45,14],[39,33,39,48],[31,9,31,24],[32,9,32,24],[32,31,32,36],[34,1,38,47],[45,33,45,38],[39,9,40,24],[41,33,41,48],[41,9,41,24]]}
["Attachment 21 - General Partner Experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N74\",\"Instructions for GP tab »\")","v":"Instructions for GP tab »"},"Necessary identification information provided","Has more than 10 affordable units","Participation didn't end 10 years ago","3+years","3+years & CTCAC","5+years","3+years & SN","3+years & active & CTCAC"]
[]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1," is missing its Project Identification Number."]
[null,null,null,null,null,null,null,{"$f":"IF(AU8,\"Developer Entity Name:\",\"General Partner Name:\")","v":"General Partner Name:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points earned:",null,null,null,null,{"$f":"BG21","v":0},null,null,null,null,null,null,null,null,null,null,"Application deadline:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," does not have more than 10 affordable units."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(1)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3," had participation end too long ago."]
[null,null,null,null,null,null,null,"Parent Company:",{"$f":"IFERROR(INDEX(GeneralPartners[ParentOrNA],MATCH(I4,GeneralPartners[GPs],0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER((SEARCH(\"Tribal applicants\",I4))),IF(AU8,\"\",\"!\"),\"\")","v":""},{"$f":"IF(Y6=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,null,4," has less than 3 full years of participation."]
[null,null,null,"Applying through Nonprofit or Special Needs set-aside and requesting points specifically for special needs housing type projects (where at least 45% of units serve special needs households).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Needs housing type:",null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"t_HousingType\",ref,0))=\"Special Needs\"","v":false},null,null,null,null,null,null,null,null,null,null,null,"info warning","units warning","participation warning","below 3 warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tribal Application:"]
[]
[null,"Project Name\nand Address",null,null,null,null,null,null,null,null,null,null,null,"Project ID. Number",null,null,null,"CTCAC Project ",null,null,"Low Income Units",null,null,"Special Needs Project",null,null,"Special Needs Units",null,null,"Date Placed in Service",null,null,null,null,"Date GP Participation Began",null,null,null,null,"Date GP Participation Ended",null,null,null,null,"Full Years of GP Participation"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AD11=\"\",AI11=\"\"),0,DATEDIF(MAX(AD11,AI11),MIN(AN11,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK11>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B11=\"\",N11=\"\"))","v":false},{"$f":"U11>10","v":false},{"$f":"OR(AN11=\"\",DATEDIF(AN11,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS11>=3,AND(AY11:BA11))","v":0},{"$f":"--AND(BB11,R11=TRUE)","v":0},{"$f":"--AND(AS11>=5,AND(AY11:BA11))","v":0},{"$f":"IFERROR(--AND(BB11,X11=TRUE,AA11/U11>=45%),0)","v":0},{"$f":"--AND(BC11,AN11=\"\")","v":0},{"$f":"AND(NOT(AY11),B11<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ11),$B11<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA11),$B11<>\"\")*$BI$6","v":0},{"$f":"AND(AS11<3,$B11<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG11:BJ11)","v":0},{"$f":"COUNTIFS($BK$11:BK11,\">0\")*(BK11>0)","v":0},{"$f":"IF(BK11>0,\"Project \"&A11&INDEX($BM$3:$BM$6,BK11),\"\")","v":""},{"$f":"IF(AN11<>\"\",1,0)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AD12=\"\",AI12=\"\"),0,DATEDIF(MAX(AD12,AI12),MIN(AN12,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK12>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B12=\"\",N12=\"\"))","v":false},{"$f":"U12>10","v":false},{"$f":"OR(AN12=\"\",DATEDIF(AN12,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS12>=3,AND(AY12:BA12))","v":0},{"$f":"--AND(BB12,R12=TRUE)","v":0},{"$f":"--AND(AS12>=5,AND(AY12:BA12))","v":0},{"$f":"IFERROR(--AND(BB12,X12=TRUE,AA12/U12>=45%),0)","v":0},{"$f":"--AND(BC12,AN12=\"\")","v":0},{"$f":"AND(NOT(AY12),B12<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ12),$B12<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA12),$B12<>\"\")*$BI$6","v":0},{"$f":"AND(AS12<3,$B12<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG12:BJ12)","v":0},{"$f":"COUNTIFS($BK$11:BK12,\">0\")*(BK12>0)","v":0},{"$f":"IF(BK12>0,\"Project \"&A12&INDEX($BM$3:$BM$6,BK12),\"\")","v":""},{"$f":"IF(AN12<>\"\",1,0)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B13=\"\",N13=\"\"))","v":false},{"$f":"U13>10","v":false},{"$f":"OR(AN13=\"\",DATEDIF(AN13,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS13>=3,AND(AY13:BA13))","v":0},{"$f":"--AND(BB13,R13=TRUE)","v":0},{"$f":"--AND(AS13>=5,AND(AY13:BA13))","v":0},0,{"$f":"--AND(BC13,AN13=\"\")","v":0},0,0,0,0,0,{"$f":"COUNTIFS($BK$11:BK13,\">0\")*(BK13>0)","v":0},{"$f":"IF(BK13>0,\"Project \"&A13&INDEX($BM$3:$BM$6,BK13),\"\")","v":""},0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B14=\"\",N14=\"\"))","v":false},{"$f":"U14>10","v":false},{"$f":"OR(AN14=\"\",DATEDIF(AN14,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS14>=3,AND(AY14:BA14))","v":0},{"$f":"--AND(BB14,R14=TRUE)","v":0},{"$f":"--AND(AS14>=5,AND(AY14:BA14))","v":0},0,{"$f":"--AND(BC14,AN14=\"\")","v":0},0,0,0,0,0,{"$f":"COUNTIFS($BK$11:BK14,\">0\")*(BK14>0)","v":0},{"$f":"IF(BK14>0,\"Project \"&A14&INDEX($BM$3:$BM$6,BK14),\"\")","v":""},0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B15=\"\",N15=\"\"))","v":false},{"$f":"U15>10","v":false},{"$f":"OR(AN15=\"\",DATEDIF(AN15,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS15>=3,AND(AY15:BA15))","v":0},{"$f":"--AND(BB15,R15=TRUE)","v":0},{"$f":"--AND(AS15>=5,AND(AY15:BA15))","v":0},0,{"$f":"--AND(BC15,AN15=\"\")","v":0},0,0,0,0,0,{"$f":"COUNTIFS($BK$11:BK15,\">0\")*(BK15>0)","v":0},{"$f":"IF(BK15>0,\"Project \"&A15&INDEX($BM$3:$BM$6,BK15),\"\")","v":""},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,null,{"$f":"SUM(BB11:BB15)","v":0},{"$f":"SUM(BC11:BC15)","v":0},{"$f":"SUM(BD11:BD15)","v":0},0,0,null,null,null,null,null,null,null,{"$f":"SUM(BN11:BN15)","v":0}]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(1:1),$BL$11:$BL$15,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH17&\"-points requires:\"","v":"5-points requires:"},null,null,3,2,1,0,"NA",{"$f":"AND($BB$16>=BB17,$BC$16>=BC17,$BD$16>=BD17,$BE$16>=BE17)*BH17","v":0},5,"3-4 projects in service more than 3 years, of which 1 shall be in service more than 5 years and 2 shall be California Low Income Housing Tax Credit projects 5 points"]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(3:3),$BL$11:$BL$15,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH18&\"-points requires:\"","v":"7-points requires:"},null,null,5,2,1,0,"NA",{"$f":"AND($BB$16>=BB18,$BC$16>=BC18,$BD$16>=BD18,$BE$16>=BE18)*BH18","v":0},7,"5 or more projects in service more than 3 years, of which 1 shall be in service more than 5 years and 2 shall be California Low Income Housing Tax Credit projects 7 points"]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(4:4),$BL$11:$BL$15,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-points requires:",null,null,0,1,0,3,"NA",{"$f":"AND($BB$16>=BB19,$BC$16>=BC19,$BD$16>=BD19,$BE$16>=BE19)*BH19*($B$8=\"Yes\")","v":0},5,"3 Special Needs projects in service more than 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the 3 special needs projects 5 points"]
[null,"Projects must have more than affordable 10 units and be subject to a recorded regulatory agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7-points requires:",null,null,0,1,0,4,"NA",{"$f":"AND($BB$16>=BB20,$BC$16>=BC20,$BD$16>=BD20,$BE$16>=BE20)*BH20*($B$8=\"Yes\")","v":0},7,"4 or more Special Needs projects in service more than 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the 4 special needs projects 7 points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(BG17:BG20)","v":0}]
[null,{"$f":"IF(BN16>4,\"Fewer than two active projects listed, must contract with a bona-fide management company. See below.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(AND(B8=\"Yes\",BF16>=1),AND(B8=\"\",BF16>=2))","v":false},"Hide bona-fide management company requirement"]
[]
[]
[]
[null,"General partners with fewer than two active California Low Income Housing Tax Credit projects in service more than three years, and general partners for projects applying through the Nonprofit or Special Needs set-aside with no active California Low Income Tax Credit projects in service more than three years, shall contract with a bona-fide management company currently managing two California Low Income Housing Tax Credit projects in service more than three years and which itself earns a minimum combined total of two points at the time of application.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[]
[]
[]
[null,"General Partner Entity:",null,null,null,null,null,null,null,{"$f":"I4","v":0}]
[]
[null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP Signature:"]
[null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"TRIBAL APPLICANTS ONLY, may contract with a developer who will not be a general partner and receive points commensurate with the developer's experience pursuant to CTCAC Regulations 10325(c)(1)(A)(i and ii). The developer may include an entity pre-approved by CTCAC that has developed but not owned the requisite number of projects described in 10325(c)(1)(A)(i). The contract shall be in effect at least until the issuance of 8609 tax forms. Tribal applicants contracting with a developer who will not be a general partner shall also contract for asset management for at least the term of the 15-year federal compliance period with an entity that has asset managed at least two Low-Income Housing Tax Credit projects for at least three years."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Developer Entity:",{"$f":"I4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tribal Applicant:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signatory Name:"]
[null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signatory Title:"]
[null,null,null,null,null,null,null,null,"Signatory Title:"]
[]
[null,null,null,null,null,null,null,null,"Developer Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Signature:"]
[null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"MC Exp","index":2,"n_rows":37,"n_cols":63,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,1,27,2],[27,3,32,48],[18,34,18,38],[18,39,18,43],[18,44,18,48],[19,1,19,12],[19,13,19,16],[19,17,19,19],[19,20,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,33],[18,13,18,16],[18,17,18,19],[18,20,18,22],[18,23,18,25],[18,26,18,28],[18,29,18,33],[19,34,19,38],[19,39,19,43],[19,44,19,48],[16,34,16,38],[16,39,16,43],[16,44,16,48],[17,1,17,12],[17,13,17,16],[17,17,17,19],[17,20,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,33],[17,34,17,38],[17,39,17,43],[17,44,17,48],[3,10,3,23],[14,1,14,12],[14,13,14,16],[14,17,14,19],[14,20,14,22],[14,23,14,25],[14,26,14,28],[14,29,14,33],[35,11,35,25],[15,1,15,12],[15,13,15,16],[15,17,15,19],[15,20,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,33],[16,1,16,12],[16,13,16,16],[16,17,16,19],[16,20,16,22],[16,23,16,25],[16,26,16,28],[16,29,16,33],[18,1,18,12],[36,11,36,25],[36,33,36,38],[13,44,13,48],[20,50,20,52],[21,50,21,52],[22,50,22,52],[23,50,23,52],[24,50,24,52],[12,44,12,48],[13,1,13,12],[13,13,13,16],[13,17,13,19],[13,20,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,33],[13,34,13,38],[13,39,13,43],[14,34,14,38],[14,39,14,43],[14,44,14,48],[15,34,15,38],[15,39,15,43],[15,44,15,48],[12,1,12,12],[12,13,12,16],[12,17,12,19],[12,20,12,22],[12,23,12,25],[12,26,12,28],[12,29,12,33],[12,34,12,38],[12,39,12,43],[10,44,10,48],[11,1,11,12],[11,13,11,16],[11,17,11,19],[11,20,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,33],[11,34,11,38],[11,39,11,43],[11,44,11,48],[10,1,10,12],[10,13,10,16],[10,17,10,19],[10,20,10,22],[10,23,10,25],[10,26,10,28],[10,29,10,33],[10,34,10,38],[10,39,10,43],[8,29,8,33],[8,44,8,48],[9,1,9,12],[9,13,9,16],[9,17,9,19],[9,20,9,22],[9,23,9,25],[9,26,9,28],[9,29,9,33],[9,34,9,38],[9,39,9,43],[8,34,8,38],[8,39,8,43],[9,44,9,48],[33,11,33,25],[5,56,8,56],[5,57,8,57],[5,58,8,58],[5,59,8,59],[8,1,8,12],[8,13,8,16],[8,17,8,19],[8,20,8,22],[8,23,8,25],[0,55,8,55],[2,31,2,33],[2,43,2,48],[3,44,3,48],[5,3,6,35],[5,46,5,48],[8,26,8,28],[0,0,0,48],[0,50,8,50],[0,51,8,51],[0,52,8,52],[0,53,8,53],[0,54,8,54],[5,1,5,2]]}
["Attachment 22 - Management Company Experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N88\",\"Instructions for MC tab »\")","v":"Instructions for MC tab »"},"Necessary identification information provided","Has more than 10 affordable units","Participation didn't end 10 years ago","3+years","3+years & CTCAC","3+years & SN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1," is missing its Project Identification Number."]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points earned:",null,null,null,null,{"$f":"BE26","v":0},null,null,null,null,null,null,null,null,null,null,"Application deadline:",{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," does not have more than 10 affordable units."]
[null,null,null,null,null,null,null,null,null,"Management Company Name:",{"$f":"Lists!AL2","v":"Barker Management, Inc."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(1)(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3," had management end too long ago."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,null,4," has less than 3 full years of management."]
[null,null,null,"Applying through Nonprofit or Special Needs set-aside and requesting points specifically for special needs housing type projects (where at least 45% of units serve special needs households).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Needs housing type:",null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"t_HousingType\",ref,0))=\"Special Needs\"","v":false},null,null,null,null,null,null,null,null,null,"info warning","units warning","participation warning","below 3 warning"]
[]
[]
[null,"Project Name\nand Address",null,null,null,null,null,null,null,null,null,null,null,"Project ID. Number",null,null,null,"CTCAC Project",null,null,"Low Income Units",null,null,"Special Needs Project",null,null,"Special Needs Units",null,null,"Date Placed in Service",null,null,null,null,"Date Management Began",null,null,null,null,"Date Management Ended",null,null,null,null,"Full Years of Management"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AD10=\"\",AI10=\"\"),0,DATEDIF(MAX(AD10,AI10),MIN(AN10,IF('GP Exp'!$AR$4=\"\",TODAY(),'GP Exp'!$AR$4)),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BI10>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B10=\"\",N10=\"\"))","v":false},{"$f":"U10>10","v":false},{"$f":"OR(AN10=\"\",DATEDIF(AN10,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS10>=3,AND(AY10:BA10))","v":0},{"$f":"--AND(BB10,R10=TRUE)","v":0},{"$f":"IFERROR(--AND(BB10,X10=TRUE,AA10/U10>=45%),0)","v":0},{"$f":"AND(NOT(AY10),B10<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ10),$B10<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA10),$B10<>\"\")*$BG$5","v":0},{"$f":"AND(AS10<3,$B10<>\"\")*$BH$5","v":0},{"$f":"MAX(BE10:BH10)","v":0},{"$f":"COUNTIFS($BI$10:BI10,\">0\")*(BI10>0)","v":0},{"$f":"IF(BI10>0,\"Project \"&A10&INDEX($BK$2:$BK$5,BI10),\"\")","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AD11=\"\",AI11=\"\"),0,DATEDIF(MAX(AD11,AI11),MIN(AN11,$AR$3,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BI11>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B11=\"\",N11=\"\"))","v":false},{"$f":"U11>10","v":false},{"$f":"OR(AN11=\"\",DATEDIF(AN11,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS11>=3,AND(AY11:BA11))","v":0},{"$f":"--AND(BB11,R11=TRUE)","v":0},{"$f":"IFERROR(--AND(BB11,X11=TRUE,AA11/U11>=45%),0)","v":0},{"$f":"AND(NOT(AY11),B11<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ11),$B11<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA11),$B11<>\"\")*$BG$5","v":0},{"$f":"AND(AS11<3,$B11<>\"\")*$BH$5","v":0},{"$f":"MAX(BE11:BH11)","v":0},{"$f":"COUNTIFS($BI$10:BI11,\">0\")*(BI11>0)","v":0},{"$f":"IF(BI11>0,\"Project \"&A11&INDEX($BK$2:$BK$5,BI11),\"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B12=\"\",N12=\"\"))","v":false},{"$f":"U12>10","v":false},{"$f":"OR(AN12=\"\",DATEDIF(AN12,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS12>=3,AND(AY12:BA12))","v":0},{"$f":"--AND(BB12,R12=TRUE)","v":0},{"$f":"IFERROR(--AND(BB12,X12=TRUE,AA12/U12>=45%),0)","v":0},{"$f":"AND(NOT(AY12),B12<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ12),$B12<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA12),$B12<>\"\")*$BG$5","v":0},{"$f":"AND(AS12<3,$B12<>\"\")*$BH$5","v":0},0,{"$f":"COUNTIFS($BI$10:BI12,\">0\")*(BI12>0)","v":0},{"$f":"IF(BI12>0,\"Project \"&A12&INDEX($BK$2:$BK$5,BI12),\"\")","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B13=\"\",N13=\"\"))","v":false},{"$f":"U13>10","v":false},{"$f":"OR(AN13=\"\",DATEDIF(AN13,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS13>=3,AND(AY13:BA13))","v":0},{"$f":"--AND(BB13,R13=TRUE)","v":0},{"$f":"IFERROR(--AND(BB13,X13=TRUE,AA13/U13>=45%),0)","v":0},{"$f":"AND(NOT(AY13),B13<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ13),$B13<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA13),$B13<>\"\")*$BG$5","v":0},{"$f":"AND(AS13<3,$B13<>\"\")*$BH$5","v":0},0,{"$f":"COUNTIFS($BI$10:BI13,\">0\")*(BI13>0)","v":0},{"$f":"IF(BI13>0,\"Project \"&A13&INDEX($BK$2:$BK$5,BI13),\"\")","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"",{"$f":"NOT(OR(B14=\"\",N14=\"\"))","v":false},{"$f":"U14>10","v":false},{"$f":"OR(AN14=\"\",DATEDIF(AN14,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS14>=3,AND(AY14:BA14))","v":0},{"$f":"--AND(BB14,R14=TRUE)","v":0},{"$f":"IFERROR(--AND(BB14,X14=TRUE,AA14/U14>=45%),0)","v":0},{"$f":"AND(NOT(AY14),B14<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ14),$B14<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA14),$B14<>\"\")*$BG$5","v":0},{"$f":"AND(AS14<3,$B14<>\"\")*$BH$5","v":0},0,{"$f":"COUNTIFS($BI$10:BI14,\">0\")*(BI14>0)","v":0},{"$f":"IF(BI14>0,\"Project \"&A14&INDEX($BK$2:$BK$5,BI14),\"\")","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"NOT(OR(B15=\"\",N15=\"\"))","v":false},{"$f":"U15>10","v":false},{"$f":"OR(AN15=\"\",DATEDIF(AN15,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS15>=3,AND(AY15:BA15))","v":0},{"$f":"--AND(BB15,R15=TRUE)","v":0},{"$f":"IFERROR(--AND(BB15,X15=TRUE,AA15/U15>=45%),0)","v":0},{"$f":"AND(NOT(AY15),B15<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ15),$B15<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA15),$B15<>\"\")*$BG$5","v":0},{"$f":"AND(AS15<3,$B15<>\"\")*$BH$5","v":0},{"$f":"MAX(BE15:BH15)","v":0},{"$f":"COUNTIFS($BI$10:BI15,\">0\")*(BI15>0)","v":0},{"$f":"IF(BI15>0,\"Project \"&A15&INDEX($BK$2:$BK$5,BI15),\"\")","v":""}]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI16,\">0\")*(BI16>0)","v":0},{"$f":"IF(BI16>0,\"Project \"&A16&INDEX($BK$2:$BK$5,BI16),\"\")","v":""}]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI17,\">0\")*(BI17>0)","v":0},{"$f":"IF(BI17>0,\"Project \"&A17&INDEX($BK$2:$BK$5,BI17),\"\")","v":""}]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI18,\">0\")*(BI18>0)","v":0},{"$f":"IF(BI18>0,\"Project \"&A18&INDEX($BK$2:$BK$5,BI18),\"\")","v":""}]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI19,\">0\")*(BI19>0)","v":0},{"$f":"IF(BI19>0,\"Project \"&A19&INDEX($BK$2:$BK$5,BI19),\"\")","v":""}]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI20,\">0\")*(BI20>0)","v":0},{"$f":"IF(BI20>0,\"Project \"&A20&INDEX($BK$2:$BK$5,BI20),\"\")","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,null,{"$f":"SUM(BB10:BB20)","v":0},{"$f":"SUM(BC10:BC20)","v":0},{"$f":"SUM(BD10:BD20)","v":0}]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(1:1),$BJ$10:$BJ$20,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF22&\"-points requires:\"","v":"2-points requires:"},null,null,6,2,0,{"$f":"AND($BB$21>=BB22,$BC$21>=BC22,$BD$21>=BD22)*BF22","v":0},2,"6-10 projects managed over 3 years, of which 2 shall be California Low Income Housing Tax Credit projects 2 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(2:2),$BJ$10:$BJ$20,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF23&\"-points requires:\"","v":"3-points requires:"},null,null,11,2,0,{"$f":"AND($BB$21>=BB23,$BC$21>=BC23,$BD$21>=BD23)*BF23","v":0},3,"11 or more projects managed over 3 years, of which 2 shall be California Low Income Housing Tax Credit projects 3 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(3:3),$BJ$10:$BJ$20,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-points requires:",null,null,0,1,2,{"$f":"AND($BB$21>=BB24,$BC$21>=BC24,$BD$21>=BD24)*BF24*($B$6=\"Yes\")","v":0},2,"2-3 Special Needs projects managed over 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the special needs projects 2 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(4:4),$BJ$10:$BJ$20,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-points requires:",null,null,0,1,4,{"$f":"AND($BB$21>=BB25,$BC$21>=BC25,$BD$21>=BD25)*BF25*($B$6=\"Yes\")","v":0},3,"4 or more Special Needs projects managed over 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the special needs projects 3 points"]
[null,"Projects must have more than affordable 10 units and be subject to a recorded regulatory agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(BE22:BE25)","v":0}]
[]
[null,null,null,"Management Companies managing less than two active California Low-Income Housing Tax Credit projects for more than three years, and management companies for projects requesting points under the special needs categories and managing no active California Low-Income Housing Tax Credit projects for more than three years, shall contract with a bona-fide management company currently managing two California Low Income Housing Tax Credit projects for more than three years and which itself earns a minimum combined total of two points at the time of application. Please provide a separate Attachment 22 form for the bona-fide management company that currently operates tax credit projects in California and which itself earns a minimum combined total of two points at the time of application."]
[]
[]
[]
[]
[]
[null,"Management Company Name: ",null,null,null,null,null,null,null,null,null,{"$f":"K4","v":"Barker Management, Inc."}]
[]
[null,"Management Principal Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Principal Signature:"]
[null,"Management Principal Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Site Control 2","index":3,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[60,32,60,33],[61,2,62,30],[57,7,57,10],[61,31,61,32],[44,12,44,16],[44,29,44,30],[59,30,59,31],[49,1,49,5],[49,20,49,24],[50,1,50,5],[50,20,50,24],[51,1,51,5],[51,20,51,24],[52,1,52,5],[52,20,52,24],[46,1,46,5],[47,1,47,5],[48,1,48,5],[48,20,48,24],[42,12,42,16],[42,26,42,30],[30,18,30,19],[33,30,33,36],[34,30,34,36],[37,7,37,10],[31,1,32,34],[40,14,40,16],[41,12,41,16],[41,26,41,30],[36,15,36,35],[37,11,37,13],[41,34,41,35],[39,32,39,35],[0,39,0,42],[24,8,24,29],[25,25,25,26],[29,12,29,34],[0,0,0,36],[3,1,3,36],[5,1,13,36],[15,30,15,36],[17,7,17,30],[22,27,22,28],[22,34,22,35],[26,14,26,36],[19,3,20,34],[21,18,21,19],[18,17,18,18]]}
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N86\",\"Instructions for Site Control tabs »\")","v":"Instructions for Site Control tabs »"}]
[]
[null,{"$f":"\"Site Control Narrative - \"&INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Site Control Narrative - Community Hub at Inglewood First UMC"}]
[null,"Provide a detailed description of how the applicable parcels are controlled by the applicant. If there are important nuances to understanding the arrangement please explain and communicate where pertinent information can be found. Including page numbers is often helpful."]
[null,null,{"$f":"INDIRECT(\"Sc\"&A1&\"Apns\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Agreement Evidencing Site Control - Site Control #\"&$A$1","v":"Agreement Evidencing Site Control - Site Control #2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(f)(2)"]
[]
[null,null,null,null,null,null,"Type of agreement:"]
[null,null,"Has the site control document been amended?"]
[null,null,null,"If yes, provide all amendments in a single file with a cover sheet and table of contents describing each amendment's purpose."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this document valid through the application filing date?",null,null,null,{"$f":"IF(S22=\"No\",\"! Expired site control documents are not accepted\",\"\")","v":""}]
[null,null,null,null,"Please specify the document and page of expiration date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See amendment:",null,null,null,null,null,null,"See page:"]
[]
[null,null,null,null,null,null,null,"Entity on title report:",{"$f":"IFERROR(INDEX(#REF!,MATCH(A1,#REF!,0)),\"The Parcels table does not show any owners for this Site Control ID\")","v":"The Parcels table does not show any owners for this Site Control ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the owner on title the party who is granting site control per the document?"]
[null,null,"Entity granting site control (aka Seller):"]
[null,null,"If no, provide a detailed explanation of how the owner has authorized the disposition and documentation of such."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Entity granted site control (aka Buyer):"]
[null,null,"Is the entity with site control the TCAC applicant?"]
[null,"If no, provide an assignment/assumption agreement granting the Applicant site control and any relevant documentation."]
[]
[null,{"$f":"\"Cost/Value Documentation - Site Control #\"&$A$1","v":"Cost/Value Documentation - Site Control #2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(6)"]
[]
[null,"All applications must include the cost or value of land and improvements in the development budget."]
[null,null,"What document is evidencing land value?"]
[null,null,null,null,null,null,"Document Date:",null,null,null,null,{"$f":"IFERROR(IF(O41=\"Value\",IF(ABS(H38-'GP Exp'!AQ4)>120,\"! Appraisals must be dated no more than 120 days prior to the application deadline\",\"\"),\"\"),\"\")","v":""}]
[]
[null,"Many applications require an appraisal to substantiate the value of land and or building improvements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10322(h)(9)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget reflects cost or valuation?"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost/Value in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraised value:",null,null,null,null,null,"See page"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds appraised value:",{"$f":"AA43>M42","v":false},null,null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds valuation:",{"$f":"MAX(0,M42-AA42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Holding cost in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of holding costs incurred:"]
[]
[null,{"$f":"INDEX(val,MATCH(\"g_LandCost\",ref,0))","v":2000000},null,null,null,null,"Land Cost or Value"]
[null,{"$f":"INDEX(val,MATCH(\"g_ImprovementsValue\",ref,0))","v":4200000},null,null,null,null,"Existing Improvements Value"]
[null,{"$f":"B47+B48","v":6200000},null,null,null,null,"Total Acquisition Cost or Value",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_HoldingCost\",ref,0))","v":125000},null,null,null,null,"Holding Costs"]
[null,{"$f":"M42","v":0},null,null,null,null,"Cost/Value on this Site Control Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45","v":0},null,null,null,null,"Holding Costs on this Site Control Tab"]
[null,{"$f":"B52-B50","v":0},null,null,null,null,"Cost/Value on other Site Control Tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52-U50","v":0},null,null,null,null,"Holding Costs on other Site Control Tabs"]
[null,{"$f":"SiteControlTotalCost","v":0},null,null,null,null,"Total Cost/Value accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HoldingTotalCost","v":0},null,null,null,null,"Total Holding Costs accounted for"]
[null,{"$f":"B49-B52","v":6200000},null,null,null,null,"Cost/Value yet to be accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U49-U52","v":125000},null,null,null,null,"Holding Costs yet to be accounted for"]
[]
[null,{"$f":"\"Title Report - Site Control #\"&$A$1","v":"Title Report - Site Control #2"}]
[]
[null,null,null,null,null,null,"Included parcels:",{"$f":"C5","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Document date:",null,null,null,null,{"$f":"IF(ABS(H58-'GP Exp'!AR4)>90,\"!\",\"\")","v":""},{"$f":"IF(L58=\"!\",\"Date is greater than 90 days from application deadline entered on GP tab.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H58=\"\",\"\",IF(('GP Exp'!$AR$4-'Site Control 2'!H58)>90,\"!\",\"\"))","v":""},{"$f":"IF(AK58=\"!\",\"Date is more than 90 days from application date\",\"\")","v":""}]
[]
[null,null,"Is this a title report or preliminary title report, not title insurance or commitment to insure?"]
[null,null,"Is this a title status report or an attorney’s opinion regarding chain of title and current title status?"]
[null,null,"Is this the site control title report of an unsuccessful application being submitted in the reapplication cycle immediately following the unsuccessful application?"]
[]
[null,null,null,null,null,null,"Note: document may only be re-submitted once"]

{"sheet":"Site Control 3","index":4,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[60,32,60,33],[61,2,62,30],[57,7,57,10],[61,31,61,32],[44,12,44,16],[44,29,44,30],[59,30,59,31],[49,1,49,5],[49,20,49,24],[50,1,50,5],[50,20,50,24],[51,1,51,5],[51,20,51,24],[52,1,52,5],[52,20,52,24],[46,1,46,5],[47,1,47,5],[48,1,48,5],[48,20,48,24],[42,12,42,16],[42,26,42,30],[30,18,30,19],[33,30,33,36],[34,30,34,36],[37,7,37,10],[31,1,32,34],[40,14,40,16],[41,12,41,16],[41,26,41,30],[36,15,36,35],[37,11,37,13],[41,34,41,35],[39,32,39,35],[0,39,0,42],[24,8,24,29],[25,25,25,26],[29,12,29,34],[0,0,0,36],[3,1,3,36],[5,1,13,36],[15,30,15,36],[17,7,17,30],[22,27,22,28],[22,34,22,35],[26,14,26,36],[19,3,20,34],[21,18,21,19],[18,17,18,18]]}
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N86\",\"Instructions for Site Control tabs »\")","v":"Instructions for Site Control tabs »"}]
[]
[null,{"$f":"\"Site Control Narrative - \"&INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Site Control Narrative - Community Hub at Inglewood First UMC"}]
[null,"Provide a detailed description of how the applicable parcels are controlled by the applicant. If there are important nuances to understanding the arrangement please explain and communicate where pertinent information can be found. Including page numbers is often helpful."]
[null,null,{"$f":"INDIRECT(\"Sc\"&A1&\"Apns\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Agreement Evidencing Site Control - Site Control #\"&$A$1","v":"Agreement Evidencing Site Control - Site Control #3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(f)(2)"]
[]
[null,null,null,null,null,null,"Type of agreement:"]
[null,null,"Has the site control document been amended?"]
[null,null,null,"If yes, provide all amendments in a single file with a cover sheet and table of contents describing each amendment's purpose."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this document valid through the application filing date?",null,null,null,{"$f":"IF(S22=\"No\",\"! Expired site control documents are not accepted\",\"\")","v":""}]
[null,null,null,null,"Please specify the document and page of expiration date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See amendment:",null,null,null,null,null,null,"See page:"]
[]
[null,null,null,null,null,null,null,"Entity on title report:",{"$f":"IFERROR(INDEX(#REF!,MATCH(A1,#REF!,0)),\"The Parcels table does not show any owners for this Site Control ID\")","v":"The Parcels table does not show any owners for this Site Control ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the owner on title the party who is granting site control per the document?"]
[null,null,"Entity granting site control (aka Seller):"]
[null,null,"If no, provide a detailed explanation of how the owner has authorized the disposition and documentation of such."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Entity granted site control (aka Buyer):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the entity with site control the TCAC applicant?",null,"Yes"]
[null,"If no, provide an assignment/assumption agreement granting the Applicant site control and any relevant documentation."]
[]
[null,{"$f":"\"Cost/Value Documentation - Site Control #\"&$A$1","v":"Cost/Value Documentation - Site Control #3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(6)"]
[]
[null,"All applications must include the cost or value of land and improvements in the development budget."]
[null,null,"What document is evidencing land value?"]
[null,null,null,null,null,null,"Document Date:",null,null,null,null,{"$f":"IFERROR(IF(O41=\"Value\",IF(ABS(H38-'GP Exp'!AQ4)>120,\"! Appraisals must be dated no more than 120 days prior to the application deadline\",\"\"),\"\"),\"\")","v":""}]
[]
[null,"Many applications require an appraisal to substantiate the value of land and or building improvements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10322(h)(9)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget reflects cost or valuation?"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost/Value in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraised value:",null,null,null,null,null,"See page"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds appraised value:",{"$f":"AA43>M42","v":false},null,null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds valuation:",{"$f":"MAX(0,M42-AA42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Holding cost in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of holding costs incurred:"]
[]
[null,{"$f":"INDEX(val,MATCH(\"g_LandCost\",ref,0))","v":2000000},null,null,null,null,"Land Cost or Value"]
[null,{"$f":"INDEX(val,MATCH(\"g_ImprovementsValue\",ref,0))","v":4200000},null,null,null,null,"Existing Improvements Value"]
[null,{"$f":"B47+B48","v":6200000},null,null,null,null,"Total Acquisition Cost or Value",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_HoldingCost\",ref,0))","v":125000},null,null,null,null,"Holding Costs"]
[null,{"$f":"M42","v":0},null,null,null,null,"Cost/Value on this Site Control Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45","v":0},null,null,null,null,"Holding Costs on this Site Control Tab"]
[null,{"$f":"B52-B50","v":0},null,null,null,null,"Cost/Value on other Site Control Tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52-U50","v":0},null,null,null,null,"Holding Costs on other Site Control Tabs"]
[null,{"$f":"SiteControlTotalCost","v":0},null,null,null,null,"Total Cost/Value accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HoldingTotalCost","v":0},null,null,null,null,"Total Holding Costs accounted for"]
[null,{"$f":"B49-B52","v":6200000},null,null,null,null,"Cost/Value yet to be accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U49-U52","v":125000},null,null,null,null,"Holding Costs yet to be accounted for"]
[]
[null,{"$f":"\"Title Report - Site Control #\"&$A$1","v":"Title Report - Site Control #3"}]
[]
[null,null,null,null,null,null,"Included parcels:",{"$f":"C5","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Document date:",null,null,null,null,{"$f":"IF(ABS(H58-'GP Exp'!AR4)>90,\"!\",\"\")","v":""},{"$f":"IF(L58=\"!\",\"Date is greater than 90 days from application deadline entered on GP tab.\",\"\")","v":""}]
[]
[null,null,"Is this a title report or preliminary title report, not title insurance or commitment to insure?"]
[null,null,"Is this a title status report or an attorney’s opinion regarding chain of title and current title status?"]
[null,null,"Is this the site control title report of an unsuccessful application being submitted in the reapplication cycle immediately following the unsuccessful application?"]
[]
[null,null,null,null,null,null,"Note: document may only be re-submitted once"]

{"sheet":"Site Control 4","index":5,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[60,32,60,33],[61,2,62,30],[57,7,57,10],[61,31,61,32],[44,12,44,16],[44,29,44,30],[59,30,59,31],[49,1,49,5],[49,20,49,24],[50,1,50,5],[50,20,50,24],[51,1,51,5],[51,20,51,24],[52,1,52,5],[52,20,52,24],[46,1,46,5],[47,1,47,5],[48,1,48,5],[48,20,48,24],[42,12,42,16],[42,26,42,30],[30,18,30,19],[33,30,33,36],[34,30,34,36],[37,7,37,10],[31,1,32,34],[40,14,40,16],[41,12,41,16],[41,26,41,30],[36,15,36,35],[37,11,37,13],[41,34,41,35],[39,32,39,35],[0,39,0,42],[24,8,24,29],[25,25,25,26],[29,12,29,34],[0,0,0,36],[3,1,3,36],[5,1,13,36],[15,30,15,36],[17,7,17,30],[22,27,22,28],[22,34,22,35],[26,14,26,36],[19,3,20,34],[21,18,21,19],[18,17,18,18]]}
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N86\",\"Instructions for Site Control tabs »\")","v":"Instructions for Site Control tabs »"}]
[]
[null,{"$f":"\"Site Control Narrative - \"&INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Site Control Narrative - Community Hub at Inglewood First UMC"}]
[null,"Provide a detailed description of how the applicable parcels are controlled by the applicant. If there are important nuances to understanding the arrangement please explain and communicate where pertinent information can be found. Including page numbers is often helpful."]
[null,null,{"$f":"INDIRECT(\"Sc\"&A1&\"Apns\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Agreement Evidencing Site Control - Site Control #\"&$A$1","v":"Agreement Evidencing Site Control - Site Control #4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(f)(2)"]
[]
[null,null,null,null,null,null,"Type of agreement:"]
[null,null,"Has the site control document been amended?"]
[null,null,null,"If yes, provide all amendments in a single file with a cover sheet and table of contents describing each amendment's purpose."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this document valid through the application filing date?",null,null,null,{"$f":"IF(S22=\"No\",\"! Expired site control documents are not accepted\",\"\")","v":""}]
[null,null,null,null,"Please specify the document and page of expiration date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See amendment:",null,null,null,null,null,null,"See page:"]
[]
[null,null,null,null,null,null,null,"Entity on title report:",{"$f":"IFERROR(INDEX(#REF!,MATCH(A1,#REF!,0)),\"The Parcels table does not show any owners for this Site Control ID\")","v":"The Parcels table does not show any owners for this Site Control ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the owner on title the party who is granting site control per the document?"]
[null,null,"Entity granting site control (aka Seller):"]
[null,null,"If no, provide a detailed explanation of how the owner has authorized the disposition and documentation of such."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Entity granted site control (aka Buyer):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the entity with site control the TCAC applicant?"]
[null,"If no, provide an assignment/assumption agreement granting the Applicant site control and any relevant documentation."]
[]
[null,{"$f":"\"Cost/Value Documentation - Site Control #\"&$A$1","v":"Cost/Value Documentation - Site Control #4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(6)"]
[]
[null,"All applications must include the cost or value of land and improvements in the development budget."]
[null,null,"What document is evidencing land value?"]
[null,null,null,null,null,null,"Document Date:","2021-05-01",null,null,null,{"$f":"IFERROR(IF(O41=\"Value\",IF(ABS(H38-'GP Exp'!AQ4)>120,\"! Appraisals must be dated no more than 120 days prior to the application deadline\",\"\"),\"\"),\"\")","v":""}]
[]
[null,"Many applications require an appraisal to substantiate the value of land and or building improvements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10322(h)(9)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget reflects cost or valuation?"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost/Value in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraised value:",null,null,null,null,null,"See page"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds appraised value:",{"$f":"AA43>M42","v":false},null,null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds valuation:",{"$f":"MAX(0,M42-AA42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Holding cost in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of holding costs incurred:"]
[]
[null,{"$f":"INDEX(val,MATCH(\"g_LandCost\",ref,0))","v":2000000},null,null,null,null,"Land Cost or Value"]
[null,{"$f":"INDEX(val,MATCH(\"g_ImprovementsValue\",ref,0))","v":4200000},null,null,null,null,"Existing Improvements Value"]
[null,{"$f":"B47+B48","v":6200000},null,null,null,null,"Total Acquisition Cost or Value",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_HoldingCost\",ref,0))","v":125000},null,null,null,null,"Holding Costs"]
[null,{"$f":"M42","v":0},null,null,null,null,"Cost/Value on this Site Control Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45","v":0},null,null,null,null,"Holding Costs on this Site Control Tab"]
[null,{"$f":"B52-B50","v":0},null,null,null,null,"Cost/Value on other Site Control Tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52-U50","v":0},null,null,null,null,"Holding Costs on other Site Control Tabs"]
[null,{"$f":"SiteControlTotalCost","v":0},null,null,null,null,"Total Cost/Value accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HoldingTotalCost","v":0},null,null,null,null,"Total Holding Costs accounted for"]
[null,{"$f":"B49-B52","v":6200000},null,null,null,null,"Cost/Value yet to be accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U49-U52","v":125000},null,null,null,null,"Holding Costs yet to be accounted for"]
[]
[null,{"$f":"\"Title Report - Site Control #\"&$A$1","v":"Title Report - Site Control #4"}]
[]
[null,null,null,null,null,null,"Included parcels:",{"$f":"C5","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Document date:",null,null,null,null,{"$f":"IF(ABS(H58-'GP Exp'!AR4)>90,\"!\",\"\")","v":""},{"$f":"IF(L58=\"!\",\"Date is greater than 90 days from application deadline entered on GP tab.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H58=\"\",\"\",IF(('GP Exp'!$AR$4-'Site Control 4'!H58)>90,\"!\",\"\"))","v":""},{"$f":"IF(AK58=\"!\",\"Date is more than 90 days from application date\",\"\")","v":""}]
[]
[null,null,"Is this a title report or preliminary title report, not title insurance or commitment to insure?"]
[null,null,"Is this a title status report or an attorney’s opinion regarding chain of title and current title status?"]
[null,null,"Is this the site control title report of an unsuccessful application being submitted in the reapplication cycle immediately following the unsuccessful application?"]
[]
[null,null,null,null,null,null,"Note: document may only be re-submitted once"]

{"sheet":"Site Control 5","index":6,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[60,32,60,33],[61,2,62,30],[57,7,57,10],[61,31,61,32],[44,12,44,16],[44,29,44,30],[59,30,59,31],[49,1,49,5],[49,20,49,24],[50,1,50,5],[50,20,50,24],[51,1,51,5],[51,20,51,24],[52,1,52,5],[52,20,52,24],[46,1,46,5],[47,1,47,5],[48,1,48,5],[48,20,48,24],[42,12,42,16],[42,26,42,30],[30,17,30,18],[33,30,33,36],[34,30,34,36],[37,7,37,10],[31,1,32,34],[40,14,40,16],[41,12,41,16],[41,26,41,30],[36,15,36,35],[37,11,37,13],[41,34,41,35],[39,32,39,35],[0,39,0,42],[24,8,24,29],[25,25,25,26],[29,12,29,34],[0,0,0,36],[3,1,3,36],[5,1,13,36],[15,30,15,36],[17,7,17,30],[22,27,22,28],[22,34,22,35],[26,14,26,36],[19,3,20,34],[21,18,21,19],[18,17,18,18]]}
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N86\",\"Instructions for Site Control tabs »\")","v":"Instructions for Site Control tabs »"}]
[]
[null,{"$f":"\"Site Control Narrative - \"&INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Site Control Narrative - Community Hub at Inglewood First UMC"}]
[null,"Provide a detailed description of how the applicable parcels are controlled by the applicant. If there are important nuances to understanding the arrangement please explain and communicate where pertinent information can be found. Including page numbers is often helpful."]
[null,null,{"$f":"INDIRECT(\"Sc\"&A1&\"Apns\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Agreement Evidencing Site Control - Site Control #\"&$A$1","v":"Agreement Evidencing Site Control - Site Control #5"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(f)(2)"]
[]
[null,null,null,null,null,null,"Type of agreement:"]
[null,null,"Has the site control document been amended?"]
[null,null,null,"If yes, provide all amendments in a single file with a cover sheet and table of contents describing each amendment's purpose."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this document valid through the application filing date?",null,null,null,{"$f":"IF(S22=\"No\",\"! Expired site control documents are not accepted\",\"\")","v":""}]
[null,null,null,null,"Please specify the document and page of expiration date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See amendment:",null,null,null,null,null,null,"See page:"]
[]
[null,null,null,null,null,null,null,"Entity on title report:",{"$f":"IFERROR(INDEX(#REF!,MATCH(A1,#REF!,0)),\"The Parcels table does not show any owners for this Site Control ID\")","v":"The Parcels table does not show any owners for this Site Control ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the owner on title the party who is granting site control per the document?","Yes"]
[null,null,"Entity granting site control (aka Seller):"]
[null,null,"If no, provide a detailed explanation of how the owner has authorized the disposition and documentation of such."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Entity granted site control (aka Buyer):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the entity with site control the TCAC applicant?"]
[null,"If no, provide an assignment/assumption agreement granting the Applicant site control and any relevant documentation."]
[]
[null,{"$f":"\"Cost/Value Documentation - Site Control #\"&$A$1","v":"Cost/Value Documentation - Site Control #5"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10325(c)(6)"]
[]
[null,"All applications must include the cost or value of land and improvements in the development budget."]
[null,null,"What document is evidencing land value?"]
[null,null,null,null,null,null,"Document Date:",null,null,null,null,{"$f":"IFERROR(IF(O41=\"Value\",IF(ABS(H38-'GP Exp'!AQ4)>120,\"! Appraisals must be dated no more than 120 days prior to the application deadline\",\"\"),\"\"),\"\")","v":""}]
[]
[null,"Many applications require an appraisal to substantiate the value of land and or building improvements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10322(h)(9)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget reflects cost or valuation?"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost/Value in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraised value:",null,null,null,null,null,"See page"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds appraised value:",{"$f":"AA43>M42","v":false},null,null,null,null,null,null,null,null,null,null,null,null,"Cost exceeds valuation:",{"$f":"MAX(0,M42-AA42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Holding cost in development budget:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of holding costs incurred:"]
[]
[null,{"$f":"INDEX(val,MATCH(\"g_LandCost\",ref,0))","v":2000000},null,null,null,null,"Land Cost or Value"]
[null,{"$f":"INDEX(val,MATCH(\"g_ImprovementsValue\",ref,0))","v":4200000},null,null,null,null,"Existing Improvements Value"]
[null,{"$f":"B47+B48","v":6200000},null,null,null,null,"Total Acquisition Cost or Value",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_HoldingCost\",ref,0))","v":125000},null,null,null,null,"Holding Costs"]
[null,{"$f":"M42","v":0},null,null,null,null,"Cost/Value on this Site Control Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45","v":0},null,null,null,null,"Holding Costs on this Site Control Tab"]
[null,{"$f":"B52-B50","v":0},null,null,null,null,"Cost/Value on other Site Control Tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52-U50","v":0},null,null,null,null,"Holding Costs on other Site Control Tabs"]
[null,{"$f":"SiteControlTotalCost","v":0},null,null,null,null,"Total Cost/Value accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HoldingTotalCost","v":0},null,null,null,null,"Total Holding Costs accounted for"]
[null,{"$f":"B49-B52","v":6200000},null,null,null,null,"Cost/Value yet to be accounted for",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U49-U52","v":125000},null,null,null,null,"Holding Costs yet to be accounted for"]
[]
[null,{"$f":"\"Title Report - Site Control #\"&$A$1","v":"Title Report - Site Control #5"}]
[]
[null,null,null,null,null,null,"Included parcels:",{"$f":"C5","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Document date:",null,null,null,null,{"$f":"IF(ABS(H58-'GP Exp'!AR4)>90,\"!\",\"\")","v":""},{"$f":"IF(L58=\"!\",\"Date is greater than 90 days from application deadline entered on GP tab.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H58=\"\",\"\",IF(('GP Exp'!$AR$4-'Site Control 5'!H58)>90,\"!\",\"\"))","v":""},{"$f":"IF(AK58=\"!\",\"Date is more than 90 days from application date\",\"\")","v":""}]
[]
[null,null,"Is this a title report or preliminary title report, not title insurance or commitment to insure?"]
[null,null,"Is this a title status report or an attorney’s opinion regarding chain of title and current title status?"]
[null,null,"Is this the site control title report of an unsuccessful application being submitted in the reapplication cycle immediately following the unsuccessful application?"]
[]
[null,null,null,null,null,null,"Note: document may only be re-submitted once"]

{"sheet":"LSQ","index":7,"n_rows":225,"n_cols":50,"rows_kept":225,"cut":false,"hidden":false,"merged":[[220,10,221,25],[222,10,222,25],[222,31,222,48],[223,10,223,25],[223,31,223,36],[216,6,216,7],[191,4,198,45],[200,4,206,45],[207,2,210,46],[214,6,214,7],[34,6,34,7],[11,4,18,45],[20,4,26,45],[27,2,30,46],[56,4,63,45],[36,6,36,7],[40,10,41,25],[42,10,42,25],[43,10,43,25],[43,31,43,36],[42,31,42,48],[65,4,71,45],[72,2,75,46],[79,6,79,7],[81,6,81,7],[85,10,86,25],[87,10,87,25],[87,31,87,48],[88,10,88,25],[88,31,88,36],[101,4,108,45],[110,4,116,45],[117,2,120,46],[124,6,124,7],[126,6,126,7],[130,10,131,25],[177,10,177,25],[177,31,177,48],[178,10,178,25],[178,31,178,36],[0,0,0,48],[2,19,2,34],[155,4,161,45],[162,2,165,46],[169,6,169,7],[171,6,171,7],[175,10,176,25],[132,10,132,25],[132,31,132,48],[133,10,133,25],[133,31,133,36],[146,4,153,45]]}
["Attachment 5 - Legal Status Questionnaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N100\",\"Instructions for LSQ tab »\")","v":"Instructions for LSQ tab »"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[]
[]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G35=\"X\",G37=\"X\"),\"!\",\"\")","v":""},{"$f":"IF(V36=\"!\",\"Both boxes cannot be selected.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Applicant Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],5),\"\")","v":"304 E. Spruce St, LP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[Type],MATCH(K41,GeneralPartners[LSQoptions],0)),\"\")","v":"Applicant"}]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A45=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y45=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Developer Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],4),\"\")","v":"BMB Housing LLC"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[Type],MATCH(K86,GeneralPartners[LSQoptions],0)),\"\")","v":"Developer"}]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A90=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y90=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Partner Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],1),\"\")","v":"304 E Spruce St. LLC"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[Type],MATCH(K131,GeneralPartners[LSQoptions],0)),\"\")","v":"General Partner"}]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A135=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y135=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,"General Partner Name:",null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],2),\"\")","v":"Central Valley Coalition for Affordable Housing"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[Type],MATCH(K176,GeneralPartners[LSQoptions],0)),\"\")","v":"General Partner"}]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,{"$f":"IF(A182=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y182=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Partner Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],3),\"\")","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[Type],MATCH(K221,GeneralPartners[LSQoptions],0)),\"\")","v":"General Partner"}]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A225=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y225=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]

{"sheet":"Zoning","index":8,"n_rows":47,"n_cols":47,"rows_kept":47,"cut":false,"hidden":false,"merged":[[11,9,11,20],[21,14,21,21],[26,3,27,43],[28,3,28,43],[25,30,25,43],[25,3,25,21],[12,9,14,20],[23,25,23,26],[25,22,25,29],[21,2,21,13],[19,2,19,25],[18,2,18,41],[13,32,14,42],[5,28,5,41],[6,28,6,41],[7,28,7,41],[4,7,5,20],[7,7,7,20],[6,7,6,20],[36,12,36,13],[46,4,49,39],[0,45,0,55],[0,0,1,43],[11,32,11,42],[12,32,12,42],[16,33,16,34],[42,7,42,26],[42,31,42,40],[43,7,43,26],[38,9,38,40],[19,36,19,37],[21,23,21,24],[30,2,32,41],[23,16,23,23],[19,26,19,33]]}
["Attachment 14 - \nVerification of Zoning and Land Use Entitlement Approvals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N110\",\"Instructions for Zoning tab »\")","v":"Instructions for Zoning tab »"}]
[]
[]
[]
[null,"Agency Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[null,"City:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
[]
[]
[]
[null,"Project Name:",null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"},null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Number of Units:",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_UnitsTotal\",ref,0))","v":60}]
[null,"Project Address/Site:",null,null,null,null,null,null,null,{"$f":"CONCATENATE(INDEX(val,MATCH(\"g_ProjectAddress\",ref,0)),\", \",CHAR(10),INDEX(val,MATCH(\"g_City\",ref,0)),\", CA \",INDEX(val,MATCH(\"g_ZipCode\",ref,0)),CHAR(10),INDEX(val,MATCH(\"g_County\",ref,0)),\" County\")","v":"411 E. Kelso St., \nInglewood, CA 90301\nLos Angeles County"},null,null,null,null,null,null,null,null,null,null,null,null,"Census Tract Number(s):",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_CensusTract\",ref,0))","v":6010.02}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessor Parcel Number(s):"]
[]
[]
[null,null,"Is this project, as proposed, zoned for the intended use or existing legal non-conforming?"]
[]
[null,null,"Are all necessary* public or tribal approvals subject to the discretion of local or tribal elected officials necessary to "]
[null,null,"begin construction are either finally approved or not applicable as of ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,"?",null,null,null,null,null,null,null,null,null,{"$f":"IF(AA20=0,\"!\",\"\")","v":"!"},{"$f":"IF(AS20=\"!\",\" Enter application deadline on GP Exp tab\",\"\")","v":" Enter application deadline on GP Exp tab"}]
[]
[null,null,"Are all appeal periods expired by ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,"?"]
[]
[null,null,null,"If no, will all appeal periods expire by",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('GP Exp'!AR4+30)","v":"1900-01-30"},null,null,null,null,null,null,null,"?"]
[]
[null,null,null,"Applicant must re-submit Attachment 14 to CTCAC by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24+7","v":"1900-02-06"},null,null,null,null,null,null,null,"as proof that either no appeals were "]
[null,null,null,"filed, or that any appeals filed during that time period were resolved within that 30-day period and the project is ready to proceed. \n"]
[]
[null,null,null,"Email proof to TCACdocs@treasurer.ca.gov."]
[]
[null,null,"*Please note, the following approvals, even if they are discretionary, are not required (by CDLAC and CTCAC) to be obtained at the time of the CDLAC and CTCAC applications: design review, initial environmental study assessments, variances, and development agreements."]
[]
[]
[]
[null,null,"Are you aware of any outstanding approvals required from the Planning Commission, City Council, Board of "]
[null,null,"Supervisors, or other agency for this project that may delay meeting 180/194 day readiness requirements,"]
[null,null,"excluding building permits?"]
[]
[null,null,"If yes, please list:"]
[]
[]
[]
[null,null,null,null,null,null,"Completed by:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AH17=\"No\",AK20=\"No\",Z24=\"No\",M37=\"Yes\"),\"!\",\"\")","v":""},{"$f":"IF(AT43=\"!\",\"Some responses selected indicate that the project may not meet readiness requirements\",\"\")","v":""}]
[null,null,null,null,null,null,null,"(signature)"]
[]
[]
[null,null,null,null,"Note: When the appeal period, if any, is concluded, the applicant must submit proof within 7 days to TCACdocs@treasurer.ca.gov that either no appeals were filed, or that any appeals filed during that time period were resolved within that 30-day period and the project is ready to proceed."]

{"sheet":"Syndication","index":9,"n_rows":50,"n_cols":50,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,14,2,29],[38,15,38,22],[39,15,39,22],[40,15,40,22],[41,15,41,22],[27,26,27,34],[24,17,24,25],[28,17,28,25],[28,26,28,34],[24,26,24,34],[17,26,17,34],[10,26,10,34],[13,26,13,34],[14,26,14,34],[15,26,15,34],[16,26,16,34],[0,49,0,50],[48,11,48,31],[49,11,49,31],[46,36,46,45],[32,3,34,45],[38,3,38,12],[40,3,40,12],[39,3,39,13],[29,35,29,43],[30,17,30,25],[30,26,30,34],[30,35,30,43],[46,11,46,31],[29,17,29,25],[29,26,29,34],[27,17,27,25],[18,26,18,34],[20,26,20,34],[21,26,21,34],[22,26,22,34],[23,26,23,34],[15,3,15,14],[28,35,28,43],[24,35,24,43],[5,35,6,43],[18,35,18,43],[20,35,20,43],[21,35,21,43],[22,35,22,43],[23,35,23,43],[10,35,10,43],[13,35,13,43],[14,35,14,43],[15,35,15,43],[16,35,16,43],[27,35,27,43],[17,35,17,43],[20,3,20,14],[10,3,10,15],[12,3,12,14],[23,17,23,25],[13,17,13,25],[14,17,14,25],[15,17,15,25],[16,17,16,25],[17,17,17,25],[18,17,18,25],[20,17,20,25],[21,17,21,25],[22,17,22,25],[21,3,21,14],[13,3,13,14],[14,3,14,14],[10,17,10,25],[16,3,16,14],[22,3,22,14],[23,3,23,5],[0,0,0,48],[2,30,2,45],[8,3,8,15],[8,17,8,25],[8,26,8,34],[8,35,8,43],[5,17,6,25],[5,26,6,34],[2,1,2,13],[23,6,23,14],[17,3,17,5],[17,6,17,14]]}
["Attachment 16 - Terms of Syndication Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N114\",\"Instructions for Syndication tab »\")","v":"Instructions for Syndication tab »"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"is interested in purchasing an interest in ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"Estimated net syndication proceeds may be calculated as follows:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal LIHTC",null,null,null,null,null,null,null,null,"State LIHTC",null,null,null,null,null,null,null,null,"Solar or Historical Tax Credit"]
[]
[]
[null,null,null,"Tax Credit Allocated (100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Gross Equity Proceeds (100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Expenses"]
[null,null,null,"Investor fees",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Organizational and offering ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Reserves or working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Investor Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R14:Z18)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA14:AI18)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ14:AR18)","v":0}]
[]
[null,null,null,"Partnership expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Legal ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Accounting ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Partnership Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R21:Z24)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA21:AI24)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ21:AR24)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses",{"$f":"SUM(R19,R25)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA19,AA25)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ19,AJ25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Equity Proceeds",{"$f":"R11-R28","v":0},null,null,null,null,null,null,null,null,{"$f":"AA11-AA28","v":0},null,null,null,null,null,null,null,null,{"$f":"AJ11-AJ28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses/Gross Proceeds",{"$f":"IFERROR(R28/R11,\"%\")","v":"%"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA28/AA11,\"%\")","v":"%"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AJ28/AJ11,\"%\")","v":"%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Proceeds Tax Credit Factor (100%)",{"$f":"IFERROR(R29/R9,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA29/AA9,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AJ29/AJ9,0)","v":0}]
[]
[null,null,null,"None of the above fees earned by the investor will be included in the project’s eligible basis.  Consistent with CTCAC Regulation Section 10322(h)(19), the syndicator shall not pay any fees or provide any other financial or other substantive benefit to a partnership developer."]
[]
[]
[]
[null,null,null,"The estimated pay-in schedule is as follows:"]
[]
[null,null,null,"Limited Partner admission",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Permanent Loan conversion",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Receipt of IRS Form 8609",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P39:V41)","v":0}]
[]
[null,null,null,"If there are any questions regarding these estimates please contact the undersigned."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Authorized Signatory:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Name of Signatory:"]
[null,null,null,null,null,null,null,null,null,null,"Title of Signatory:"]

{"sheet":"Impact Fees","index":10,"n_rows":47,"n_cols":50,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,49,0,50],[38,8,38,27],[38,28,38,38],[33,8,33,10],[33,11,33,27],[34,8,34,10],[34,11,34,27],[35,8,35,10],[35,11,35,27],[36,8,36,10],[36,11,36,27],[35,28,35,38],[36,28,36,38],[37,28,37,38],[37,8,37,10],[37,11,37,27],[33,28,33,38],[34,28,34,38],[22,28,22,38],[23,8,23,27],[23,28,23,38],[24,8,24,27],[24,28,24,38],[25,8,25,27],[25,28,25,38],[29,8,29,27],[29,28,29,38],[26,8,26,27],[26,28,26,38],[27,8,27,27],[21,8,21,27],[21,28,21,38],[32,8,32,27],[32,28,32,38],[30,8,30,27],[30,28,30,38],[31,8,31,27],[31,28,31,38],[28,8,28,27],[28,28,28,38],[27,28,27,38],[22,8,22,27],[46,11,46,31],[43,36,43,45],[41,11,41,31],[41,36,41,45],[42,36,42,45],[42,11,42,31],[43,11,43,31],[19,8,19,27],[19,28,19,38],[20,8,20,27],[18,28,18,38],[0,0,0,48],[3,9,3,43],[5,3,6,44],[8,3,11,45],[12,3,13,45],[16,8,16,27],[16,28,16,38],[17,8,17,27],[17,28,17,38],[18,8,18,27],[20,28,20,38]]}
["Attachment 18A - Local Development Impact Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N123\",\"Instructions for Impact Fees tab »\")","v":"Instructions for Impact Fees tab »"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"Project Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[null,null,null,"Itemize all local impact fees to be paid. The total must correspond with the total local impact fees line item shown in the development budget of the application.\n"]
[]
[]
[null,null,null,"Pursuant to Regulation Section 10302(bb), Local development impact fees are defined as: The amount of impact fees, mitigation fees, or capital facilities fees imposed by municipalities, county agencies, or other jurisdictions such as public utility districts, school districts, water agencies, resource conservation districts, etc."]
[]
[]
[]
[null,null,null,"NOTE: Permit processing fees, building permit fees, and plan check fees are NOT considered local development impact fees.\n"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Type of Fees to be Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount of Fee"]
[null,null,null,null,null,null,null,null,"Community Development Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Drainage Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Facilities Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Fire Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"General Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Governmental/Environmental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Law Enforcement Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Library Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Parks & Recreation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Public Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Schools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Streets & Signals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Traffic Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Waste Water Collection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Waste Water Treatment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Water Facilities ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total Local Development Impact Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC18:AM38)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Agency/Jurisdiction Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,null,null,null,null,null,null,null,null,null,"Name of Signatory:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,null,null,null,null,null,null,null,null,null,"Title of Signatory:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Signature:"]

{"sheet":"Architect","index":11,"n_rows":82,"n_cols":50,"rows_kept":82,"cut":false,"hidden":false,"merged":[[23,6,28,45],[0,49,0,50],[58,3,58,4],[77,9,77,29],[62,3,62,4],[65,6,66,45],[65,3,65,4],[70,0,70,48],[71,3,74,45],[0,0,0,48],[3,9,3,43],[5,3,6,44],[81,9,81,29],[7,3,7,4],[7,6,8,45],[10,3,10,4],[12,6,14,45],[12,3,12,4],[76,9,76,29],[62,6,63,45],[16,3,16,4],[18,3,18,4],[20,3,20,4],[20,6,21,45],[23,3,23,4],[30,3,30,4],[30,6,35,45],[78,9,78,29],[78,36,78,45],[37,3,37,4],[37,6,43,45],[45,3,45,4],[45,6,48,45],[76,31,77,35],[76,36,77,45],[50,3,50,4],[50,6,52,45],[54,6,56,45],[54,3,54,4],[58,6,60,44]]}
["Attachment 18B - Architect Threshold Basis Limit Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N134\",\"Instructions for Architect tab »\")","v":"Instructions for Architect tab »"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"Project Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[null,null,null,"CHECK THE RELEVANT/APPROPRIATE BOXES TO THE PROJECT AND SIGN AS INDICATED:"]
[]
[null,null,null,null,null,null,"Provide parking beneath residential units (but not “tuck under” parking) or through construction of an on-site parking structure of two or more levels."]
[]
[]
[null,null,null,null,null,null,"Day care center is part of the project."]
[]
[null,null,null,null,null,null,"The lesser of the associated costs or up to a 15% basis adjustment for projects requiring seismic upgrading of existing structures, and/ or projects requiring toxic or other environmental mitigation.\n(Must attach additional project architect or seismic engineer verification of estimated cost.)"]
[]
[]
[]
[null,null,null,null,null,null,"At least 95% of upper floor units are serviced by elevator(s)."]
[]
[null,null,null,null,null,null,"At least 95% of the building(s) is constructed as Type I as defined in the California Building Code."]
[]
[null,null,null,null,null,null,"At least 95% of the building(s) is constructed as either a Type III as defined in the California Building Code, or a Type III/Type I combination."]
[]
[]
[null,null,null,null,null,null,"Projects shall have onsite renewable generation estimated to produce 50% or more of annual tenant electricity use. If the combined available roof area of the project structures, including carports, is insufficient for provision of 50% of annual electricity use, then the project shall have onsite renewable generation based on at least 90% of the available solar accessible roof area. Available solar accessible area is defined as roof area less north facing roof area for sloped roofs, equipment, solar thermal hot water, and required local or state fire department set-backs and access routes."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Project shall have onsite renewable generation estimated to produce 75% or more of annual common area electricity use. If the combined available roof area of the project structures including carports is insufficient for provision of 75% of annual electricity use, then the project shall have onsite renewable generation based on at least 90% of the available solar accessible roof area. Available solar accessible area is defined as roof area less north facing roof area for sloped roofs, equipment, solar thermal hot water, and required local or state fire department set-backs and access routes."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Newly constructed project buildings shall be 15% more energy efficient than the applicable Building Energy Efficiency Standards (Energy Code, California Code of Regulations, Title 24) for energy efficiency alone (not counting solar), except that if the local building department has determined that building permit applications submitted on or before December 31, 2019 are complete, then newly constructed project buildings shall be fifteen percent (15%) or more energy efficient than the 2016 Energy Efficiency Standards (California Code of Regulations, Title 24). \n(must submit a Sustainable Building Method Workbook.)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rehabilitation project buildings shall have an 80% decrease in TDV energy use (or improvement in energy efficiency) post rehabilitation as demonstrated using the appropriate performance module of CEC approved software.\n(must submit a Sustainable Building Method Workbook.)"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Irrigate only with reclaimed water, greywater, or rainwater (excepting water used for Community Gardens) or irrigate with reclaimed water, greywater, or rainwater in an amount that annually equals or exceeds 20,000 gallons or 300 gallons per unit, whichever is less.\n"]
[]
[]
[]
[null,null,null,null,null,null,"Community Gardens of at least 60 square feet per unit. Permanent site improvements that provide a viable growing space within the project including solar access, fencing, watering systems, secure storage space for tools, and pedestrian access.\n"]
[]
[]
[]
[null,null,null,null,null,null,"Install bamboo, stained concrete, cork, salvaged or FSC-Certified wood, natural linoleum, natural rubber, or ceramic tile in all kitchens, living rooms, and bathrooms (where no VOC adhesives or backing is also used)."]
[]
[]
[]
[null,null,null,null,null,null,"Install bamboo, stained concrete, cork, salvaged or FSC-Certified wood, natural linoleum, natural rubber, or ceramic tile in all common areas (where no VOC adhesives or backing is also used)."]
[]
[]
[null,null,null,null,null,null,"For new construction projects, meet all requirements of the U.S. Environmental Protection Agency indoor Air Plus Program."]
[]
[]
[]
[]
["ARCHITECT CERTIFICATION"]
[null,null,null,"I/We, as the architectural firm contractually responsible for the design and supervision (if applicable) of the above referenced project, certify as defined by Business and Professions Code Section 5536.26, under penalty of perjury, that each of the individual items identified in the threshold basis limit section of this application will be incorporated into the design of the project to which this application applies."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Firm Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State and License # :"]
[null,null,null,null,null,null,null,null,"Architect Name:"]
[null,null,null,null,null,null,null,null,"Architect Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Signature:"]

{"sheet":"Accessibility","index":12,"n_rows":40,"n_cols":50,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,9,36,29],[36,36,36,45],[39,9,39,29],[9,8,10,45],[12,8,13,45],[14,8,15,45],[16,8,19,45],[22,8,23,45],[24,8,25,45],[28,0,28,48],[29,3,32,45],[34,9,34,29],[34,31,35,35],[34,36,35,45],[35,9,35,29],[0,49,0,50],[0,0,0,48],[3,9,3,43],[5,3,6,44],[7,3,7,4],[7,6,8,45]]}
["Attachment 27 - Enhanced Accessibility and Visitability Architect Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N139\",\"Instructions for Accessibility tab »\")","v":"Instructions for Accessibility tab »"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"Project Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[null,null,null,"CHECK THE RELEVANT/APPROPRIATE BOXES TO THE PROJECT AND SIGN AS INDICATED:"]
[]
[null,null,null,null,null,null,"Project design incorporates California Building Code Chapter 11(B) and the principles of Universal Design in at least half of the project's Low-Income Units by including: "]
[]
[null,null,null,null,null,null,null,"•","Accessible routes of travel to the dwelling units with accessible 34” minimum clear-opening-width entry, and 34” clear width for all doors on an accessible path.\n"]
[]
[null,null,null,null,null,null,null,"•","Interior doors with lever hardware and 42” minimum width hallways"]
[null,null,null,null,null,null,null,"•","Fully accessible bathrooms complying with California Building Code (CBC) Chapter 11(A) and 11(B). In addition 30” x 48” clearance parallel to and centered on the bathroom vanity.\n"]
[]
[null,null,null,null,null,null,null,"•","Accessible kitchens with 30” x 48” clearance parallel to and centered on front of all major appliances and fixtures (refrigerator, oven, dishwasher and sink).\n"]
[]
[null,null,null,null,null,null,null,"•","Accessible master bedroom size shall be at least 120 square feet (excluding the closet), shall accommodate a queen size bed, shall provide 36” in clearance around three sides of the bed, and shall provide required accessible clearances, free of all furnishings, at bedroom and closet doors. The master bedroom closet shall be on an accessible path.\n"]
[]
[]
[]
[null,null,null,null,null,null,null,"•","Wiring for audio and visual doorbells required by UFAS shall be installed."]
[null,null,null,null,null,null,null,"•","Closets, balconies, shall be located on an accessible route."]
[null,null,null,null,null,null,null,"•","These units shall, to the maximum extent feasible and subject to reasonable health and safety requirements, be distributed throughout the project consistent with 24 CFR Section 8.26."]
[]
[null,null,null,null,null,null,null,"•","Applicant must commit to obtaining confirmation from a Certified Accessibility Specialist that the above requirements have been met."]
[]
[]
[]
["ARCHITECT CERTIFICATION"]
[null,null,null,"I/We, as the architectural firm contractually responsible for the design and supervision (if applicable) of the above referenced project, certify as defined by Business and Professions Code Section 5536.26, under penalty of perjury, that each of the individual items identified in the miscellaneous Federal and State Policies section of this application will be incorporated into the design of the project to which this application applies."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Firm Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State and License # :"]
[null,null,null,null,null,null,null,null,"Architect Name:"]
[null,null,null,null,null,null,null,null,"Architect Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Signature:"]

{"sheet":"Farmworker","index":13,"n_rows":17,"n_cols":50,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,9,15,29],[16,9,16,29],[15,36,15,45],[0,49,0,50],[6,0,6,48],[0,0,0,48],[3,9,3,43],[14,9,14,29],[7,3,10,45]]}
["Attachment 28 - Farmworker State Credit Eligibility Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"#Instructions!N144\",\"Instructions for Farmworker tab »\")","v":"Instructions for Farmworker tab »"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10302(p), 10310(b)(2)(D), and 10317"]
[]
[null,null,null,"Project Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":"Community Hub at Inglewood First UMC"}]
[]
[]
["APPLICANT CERTIFICATION"]
[null,null,null,"I/We, who are authorized to legally act on the applicant’s behalf, certify and guarantee, under penalty of perjury, that the proposed development of permanent housing will be housing in which at least 50 percent of the units are available to and occupied by farmworkers and their families (as defined by California Labor Code Section 1140.4(b))."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Authorized Signature:"]
[null,null,null,null,null,null,null,null,"Name of Signatory:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"Applicant Name:",{"$f":"INDEX(val,MATCH(\"g_TcacApplicant\",ref,0))","v":"304 E. Spruce St, LP"}]

{"sheet":"Data","index":14,"n_rows":193,"n_cols":21,"rows_kept":193,"cut":false,"hidden":true,"merged":[]}
["Reference","Value","Description",null,null,"Bedroom Type","Number of Units","Average Sq Ft","Net Rent","Monthly Utility","Targeted % AMI","Count SpN Units","Market Rate",null,"Average Affordability by AMI Actual Rents - SpN",null,null,null,"Average Affordability by AMI Actual Rents - Non-SpN SRO"]
[null,"Project Location",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B718=\"\",\"\",[1]Application!$B718),IF([1]Application!$B695=\"\",\"\",[1]Application!$B695))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G718=\"\",\"\",[1]Application!$G718),IF([1]Application!$G695=\"\",\"\",[1]Application!$G695))","v":11},{"$f":"IF(CreditType=4,IF([1]Application!$K718=\"\",\"\",[1]Application!$K718),IF([1]Application!$K695=\"\",\"\",[1]Application!$K695))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O718=\"\",\"\",[1]Application!$O718),IF([1]Application!$O695=\"\",\"\",[1]Application!$O695))","v":613},{"$f":"IF(CreditType=4,IF([1]Application!$T718=\"\",\"\",[1]Application!$T718),IF([1]Application!$Y695=\"\",\"\",[1]Application!$Y695))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC718,[1]Application!$AH695)","v":0.3},null,null,null,"Units","Unit % of Total","Pro Rata Target %",null,"Units","Unit % of Total","Pro Rata Target %"]
["g_ProjectName",{"$f":"IF(CreditType=4,[1]Application!$H$18,IF(CreditType=9,[1]Application!$H$17,\"Use a current e-app in order to link\"))","v":"Community Hub at Inglewood First UMC"},"Name of the project",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B719=\"\",\"\",[1]Application!$B719),IF([1]Application!$B696=\"\",\"\",[1]Application!$B696))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G719=\"\",\"\",[1]Application!$G719),IF([1]Application!$G696=\"\",\"\",[1]Application!$G696))","v":11},{"$f":"IF(CreditType=4,IF([1]Application!$K719=\"\",\"\",[1]Application!$K719),IF([1]Application!$K696=\"\",\"\",[1]Application!$K696))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O719=\"\",\"\",[1]Application!$O719),IF([1]Application!$O696=\"\",\"\",[1]Application!$O696))","v":834},{"$f":"IF(CreditType=4,IF([1]Application!$T719=\"\",\"\",[1]Application!$T719),IF([1]Application!$Y696=\"\",\"\",[1]Application!$Y696))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC719,[1]Application!$AH696)","v":0.4},null,null,null,{"$f":"IF(OR(L2=\"\",L2=0),\"\",L2)","v":""},{"$f":"IF(OR(O3=\"\",O3=0),\"\",O3/$O$37)","v":""},{"$f":"IF(OR(P3=0,P3=\"\"),\"\",P3*K2)","v":""},null,{"$f":"IF(F2=\"SRO/Studio\",G2-L2,\"\")","v":11},{"$f":"IF(OR(S3=\"\",S3=0),\"\",S3/$S$37)","v":0.1864406779661017},{"$f":"IF(OR(T3=0,T3=\"\"),\"\",T3*$K2)","v":5.5932203389830508E-2}]
["g_ProjectAddress",{"$f":"IF([1]Application!$I$185=\"\",[1]Application!$E$187,[1]Application!$I$185)","v":"411 E. Kelso St."},"Primary address of site",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B720=\"\",\"\",[1]Application!$B720),IF([1]Application!$B697=\"\",\"\",[1]Application!$B697))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G720=\"\",\"\",[1]Application!$G720),IF([1]Application!$G697=\"\",\"\",[1]Application!$G697))","v":3},{"$f":"IF(CreditType=4,IF([1]Application!$K720=\"\",\"\",[1]Application!$K720),IF([1]Application!$K697=\"\",\"\",[1]Application!$K697))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O720=\"\",\"\",[1]Application!$O720),IF([1]Application!$O697=\"\",\"\",[1]Application!$O697))","v":1053},{"$f":"IF(CreditType=4,IF([1]Application!$T720=\"\",\"\",[1]Application!$T720),IF([1]Application!$Y697=\"\",\"\",[1]Application!$Y697))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC720,[1]Application!$AH697)","v":0.5},null,null,null,{"$f":"IF(OR(L3=\"\",L3=0),\"\",L3)","v":""},{"$f":"IF(OR(O4=\"\",O4=0),\"\",O4/$O$37)","v":""},{"$f":"IF(OR(P4=0,P4=\"\"),\"\",P4*K3)","v":""},null,{"$f":"IF(F3=\"SRO/Studio\",G3-L3,\"\")","v":11},{"$f":"IF(OR(S4=\"\",S4=0),\"\",S4/$S$37)","v":0.1864406779661017},{"$f":"IF(OR(T4=0,T4=\"\"),\"\",T4*$K3)","v":7.4576271186440682E-2}]
["g_City",{"$f":"[1]Application!$I$189","v":"Inglewood"},"City",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B721=\"\",\"\",[1]Application!$B721),IF([1]Application!$B698=\"\",\"\",[1]Application!$B698))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G721=\"\",\"\",[1]Application!$G721),IF([1]Application!$G698=\"\",\"\",[1]Application!$G698))","v":2},{"$f":"IF(CreditType=4,IF([1]Application!$K721=\"\",\"\",[1]Application!$K721),IF([1]Application!$K698=\"\",\"\",[1]Application!$K698))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O721=\"\",\"\",[1]Application!$O721),IF([1]Application!$O698=\"\",\"\",[1]Application!$O698))","v":1274},{"$f":"IF(CreditType=4,IF([1]Application!$T721=\"\",\"\",[1]Application!$T721),IF([1]Application!$Y698=\"\",\"\",[1]Application!$Y698))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC721,[1]Application!$AH698)","v":0.6},null,null,null,"","","",null,3,5.0847457627118647E-2,2.5423728813559324E-2]
["g_ZipCode",{"$f":"[1]Application!$I$190","v":90301},"Zip Code",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B722=\"\",\"\",[1]Application!$B722),IF([1]Application!$B699=\"\",\"\",[1]Application!$B699))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G722=\"\",\"\",[1]Application!$G722),IF([1]Application!$G699=\"\",\"\",[1]Application!$G699))","v":1},{"$f":"IF(CreditType=4,IF([1]Application!$K722=\"\",\"\",[1]Application!$K722),IF([1]Application!$K699=\"\",\"\",[1]Application!$K699))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O722=\"\",\"\",[1]Application!$O722),IF([1]Application!$O699=\"\",\"\",[1]Application!$O699))","v":1550},{"$f":"IF(CreditType=4,IF([1]Application!$T722=\"\",\"\",[1]Application!$T722),IF([1]Application!$Y699=\"\",\"\",[1]Application!$Y699))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC722,[1]Application!$AH699)","v":0.8},null,null,null,"","","",null,2,3.3898305084745763E-2,2.0338983050847456E-2]
["g_ScatteredSite",{"$f":"IF(CreditType=4,[1]Application!$T$196=\"Yes\",[1]Application!$AI$194=\"Yes\")","v":false},"If the project involves multiple scattered sites",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B723=\"\",\"\",[1]Application!$B723),IF([1]Application!$B700=\"\",\"\",[1]Application!$B700))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G723=\"\",\"\",[1]Application!$G723),IF([1]Application!$G700=\"\",\"\",[1]Application!$G700))","v":4},{"$f":"IF(CreditType=4,IF([1]Application!$K723=\"\",\"\",[1]Application!$K723),IF([1]Application!$K700=\"\",\"\",[1]Application!$K700))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O723=\"\",\"\",[1]Application!$O723),IF([1]Application!$O700=\"\",\"\",[1]Application!$O700))","v":612.80999999999995},{"$f":"IF(CreditType=4,IF([1]Application!$T723=\"\",\"\",[1]Application!$T723),IF([1]Application!$Y700=\"\",\"\",[1]Application!$Y700))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC723,[1]Application!$AH700)","v":0.3},null,null,null,"","","",null,1,1.6949152542372881E-2,1.3559322033898306E-2]
["g_CensusTract",{"$f":"[1]Application!$T$190","v":6010.02},"Census tract project resides in",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B724=\"\",\"\",[1]Application!$B724),IF([1]Application!$B701=\"\",\"\",[1]Application!$B701))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G724=\"\",\"\",[1]Application!$G724),IF([1]Application!$G701=\"\",\"\",[1]Application!$G701))","v":4},{"$f":"IF(CreditType=4,IF([1]Application!$K724=\"\",\"\",[1]Application!$K724),IF([1]Application!$K701=\"\",\"\",[1]Application!$K701))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O724=\"\",\"\",[1]Application!$O724),IF([1]Application!$O701=\"\",\"\",[1]Application!$O701))","v":834},{"$f":"IF(CreditType=4,IF([1]Application!$T724=\"\",\"\",[1]Application!$T724),IF([1]Application!$Y701=\"\",\"\",[1]Application!$Y701))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC724,[1]Application!$AH701)","v":0.4},null,null,null,"","","",null,4,6.7796610169491525E-2,2.0338983050847456E-2]
["g_County",{"$f":"[1]Application!$T$189","v":"Los Angeles"},"County project resides in",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B725=\"\",\"\",[1]Application!$B725),IF([1]Application!$B702=\"\",\"\",[1]Application!$B702))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G725=\"\",\"\",[1]Application!$G725),IF([1]Application!$G702=\"\",\"\",[1]Application!$G702))","v":6},{"$f":"IF(CreditType=4,IF([1]Application!$K725=\"\",\"\",[1]Application!$K725),IF([1]Application!$K702=\"\",\"\",[1]Application!$K702))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O725=\"\",\"\",[1]Application!$O725),IF([1]Application!$O702=\"\",\"\",[1]Application!$O702))","v":1053},{"$f":"IF(CreditType=4,IF([1]Application!$T725=\"\",\"\",[1]Application!$T725),IF([1]Application!$Y702=\"\",\"\",[1]Application!$Y702))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC725,[1]Application!$AH702)","v":0.5},null,null,null,"","","",null,4,6.7796610169491525E-2,2.7118644067796613E-2]
["g_DdaStatus",{"$f":"IF(CreditType=4,[1]Application!$T$195=\"Yes\",[1]Application!$T$193=\"Yes\")","v":false},"TRUE if designated a Difficult Development Area",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B726=\"\",\"\",[1]Application!$B726),IF([1]Application!$B703=\"\",\"\",[1]Application!$B703))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G726=\"\",\"\",[1]Application!$G726),IF([1]Application!$G703=\"\",\"\",[1]Application!$G703))","v":8},{"$f":"IF(CreditType=4,IF([1]Application!$K726=\"\",\"\",[1]Application!$K726),IF([1]Application!$K703=\"\",\"\",[1]Application!$K703))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O726=\"\",\"\",[1]Application!$O726),IF([1]Application!$O703=\"\",\"\",[1]Application!$O703))","v":1274},{"$f":"IF(CreditType=4,IF([1]Application!$T726=\"\",\"\",[1]Application!$T726),IF([1]Application!$Y703=\"\",\"\",[1]Application!$Y703))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC726,[1]Application!$AH703)","v":0.6},null,null,null,"","","",null,6,0.10169491525423729,5.0847457627118647E-2]
["g_QctStatus",{"$f":"IF(CreditType=4,[1]Application!$T$196=\"Yes\",[1]Application!$T$194=\"Yes\")","v":false},"TRUE if in a Qualified Census Tract",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B727=\"\",\"\",[1]Application!$B727),IF([1]Application!$B704=\"\",\"\",[1]Application!$B704))","v":"SRO/Studio"},{"$f":"IF(CreditType=4,IF([1]Application!$G727=\"\",\"\",[1]Application!$G727),IF([1]Application!$G704=\"\",\"\",[1]Application!$G704))","v":9},{"$f":"IF(CreditType=4,IF([1]Application!$K727=\"\",\"\",[1]Application!$K727),IF([1]Application!$K704=\"\",\"\",[1]Application!$K704))","v":405},{"$f":"IF(CreditType=4,IF([1]Application!$O727=\"\",\"\",[1]Application!$O727),IF([1]Application!$O704=\"\",\"\",[1]Application!$O704))","v":1550},{"$f":"IF(CreditType=4,IF([1]Application!$T727=\"\",\"\",[1]Application!$T727),IF([1]Application!$Y704=\"\",\"\",[1]Application!$Y704))","v":49.19},{"$f":"IF(CreditType=4,[1]Application!$AC727,[1]Application!$AH704)","v":0.8},null,null,null,"","","",null,8,0.13559322033898305,8.1355932203389825E-2]
["g_OpportunityArea",{"$f":"IF(CreditType=4,[1]Application!$T$193,[1]Application!$R$199)","v":"Low Resource"},"Opportunity map designation",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B728=\"\",\"\",[1]Application!$B728),IF([1]Application!$B705=\"\",\"\",[1]Application!$B705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G728=\"\",\"\",[1]Application!$G728),IF([1]Application!$G705=\"\",\"\",[1]Application!$G705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K728=\"\",\"\",[1]Application!$K728),IF([1]Application!$K705=\"\",\"\",[1]Application!$K705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O728=\"\",\"\",[1]Application!$O728),IF([1]Application!$O705=\"\",\"\",[1]Application!$O705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T728=\"\",\"\",[1]Application!$T728),IF([1]Application!$Y705=\"\",\"\",[1]Application!$Y705))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC728,[1]Application!$AH705)","v":0},null,null,null,"","","",null,9,0.15254237288135594,0.12203389830508476]
["g_DistrictFederalCongressional",{"$f":"IF(CreditType=4,[1]Application!$AH$195,[1]Application!$O$225)","v":43},"Federal Congressional District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B729=\"\",\"\",[1]Application!$B729),IF([1]Application!$B706=\"\",\"\",[1]Application!$B706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G729=\"\",\"\",[1]Application!$G729),IF([1]Application!$G706=\"\",\"\",[1]Application!$G706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K729=\"\",\"\",[1]Application!$K729),IF([1]Application!$K706=\"\",\"\",[1]Application!$K706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O729=\"\",\"\",[1]Application!$O729),IF([1]Application!$O706=\"\",\"\",[1]Application!$O706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T729=\"\",\"\",[1]Application!$T729),IF([1]Application!$Y706=\"\",\"\",[1]Application!$Y706))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC729,[1]Application!$AH706)","v":0},null,null,null,"","","",null,"","",""]
["g_DistrictStateAssembly",{"$f":"IF(CreditType=4,[1]Application!$AH$196,[1]Application!$O$226)","v":61},"State Assembly District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B730=\"\",\"\",[1]Application!$B730),IF([1]Application!$B707=\"\",\"\",[1]Application!$B707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G730=\"\",\"\",[1]Application!$G730),IF([1]Application!$G707=\"\",\"\",[1]Application!$G707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K730=\"\",\"\",[1]Application!$K730),IF([1]Application!$K707=\"\",\"\",[1]Application!$K707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O730=\"\",\"\",[1]Application!$O730),IF([1]Application!$O707=\"\",\"\",[1]Application!$O707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T730=\"\",\"\",[1]Application!$T730),IF([1]Application!$Y707=\"\",\"\",[1]Application!$Y707))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC730,[1]Application!$AH707)","v":0},null,null,null,"","","",null,"","",""]
["g_DistrictStateSenate",{"$f":"IF(CreditType=4,[1]Application!$AH$197,[1]Application!$O$227)","v":35},"State Senate District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B731=\"\",\"\",[1]Application!$B731),IF([1]Application!$B708=\"\",\"\",[1]Application!$B708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G731=\"\",\"\",[1]Application!$G731),IF([1]Application!$G708=\"\",\"\",[1]Application!$G708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K731=\"\",\"\",[1]Application!$K731),IF([1]Application!$K708=\"\",\"\",[1]Application!$K708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O731=\"\",\"\",[1]Application!$O731),IF([1]Application!$O708=\"\",\"\",[1]Application!$O708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T731=\"\",\"\",[1]Application!$T731),IF([1]Application!$Y708=\"\",\"\",[1]Application!$Y708))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC731,[1]Application!$AH708)","v":0},null,null,null,"","","",null,"","",""]
["g_GeographicArea",{"$f":"IF(CreditType=4,IF(ISNUMBER(SEARCH(\":\",[1]Application!$D$220)),LEFT([1]Application!$D$220,SEARCH(\":\",[1]Application!$D$220)-1),[1]Application!$D$220),IF(ISNUMBER(SEARCH(\":\",[1]Application!$D$223)),LEFT([1]Application!$D$223,SEARCH(\":\",[1]Application!$D$223)-1),[1]Application!$D$223))","v":"Balance of Los Angeles County"},"Geographic Region",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B732=\"\",\"\",[1]Application!$B732),IF([1]Application!$B709=\"\",\"\",[1]Application!$B709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G732=\"\",\"\",[1]Application!$G732),IF([1]Application!$G709=\"\",\"\",[1]Application!$G709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K732=\"\",\"\",[1]Application!$K732),IF([1]Application!$K709=\"\",\"\",[1]Application!$K709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O732=\"\",\"\",[1]Application!$O732),IF([1]Application!$O709=\"\",\"\",[1]Application!$O709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T732=\"\",\"\",[1]Application!$T732),IF([1]Application!$Y709=\"\",\"\",[1]Application!$Y709))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC732,[1]Application!$AH709)","v":0},null,null,null,"","","",null,"","",""]
[null,"Project Characteristics",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B733=\"\",\"\",[1]Application!$B733),IF([1]Application!$B710=\"\",\"\",[1]Application!$B710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G733=\"\",\"\",[1]Application!$G733),IF([1]Application!$G710=\"\",\"\",[1]Application!$G710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K733=\"\",\"\",[1]Application!$K733),IF([1]Application!$K710=\"\",\"\",[1]Application!$K710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O733=\"\",\"\",[1]Application!$O733),IF([1]Application!$O710=\"\",\"\",[1]Application!$O710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T733=\"\",\"\",[1]Application!$T733),IF([1]Application!$Y710=\"\",\"\",[1]Application!$Y710))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC733,[1]Application!$AH710)","v":0},null,null,null,"","","",null,"","",""]
["g_TaxCredits",{"$f":"[1]Application!$AS$1","v":4},"Type of tax credits",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B734=\"\",\"\",[1]Application!$B734),IF([1]Application!$B711=\"\",\"\",[1]Application!$B711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G734=\"\",\"\",[1]Application!$G734),IF([1]Application!$G711=\"\",\"\",[1]Application!$G711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K734=\"\",\"\",[1]Application!$K734),IF([1]Application!$K711=\"\",\"\",[1]Application!$K711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O734=\"\",\"\",[1]Application!$O734),IF([1]Application!$O711=\"\",\"\",[1]Application!$O711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T734=\"\",\"\",[1]Application!$T734),IF([1]Application!$Y711=\"\",\"\",[1]Application!$Y711))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC734,[1]Application!$AH711)","v":0},null,null,null,"","","",null,"","",""]
["g_Rural",{"$f":"IF(CreditType=4,IF([1]Application!$Z$199=\"Yes\",TRUE,IF(OR([1]Application!$D$211=\"Rural\",[1]Application!$D$211=\"Rural apportionment (Section 514)\",[1]Application!$D$211=\"Rural apportionment (CDBG-DR)\",[1]Application!$D$211=\"Rural apportionment (Section 515)\",[1]Application!$D$211=\"Rural apportionment (HOME)\",[1]Application!$D$211=\"Rural apportionment (Native American apportionment)\",[1]Application!$D$223=\"(select one)\"),TRUE,FALSE)))","v":false},"Rural",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B735=\"\",\"\",[1]Application!$B735),IF([1]Application!$B712=\"\",\"\",[1]Application!$B712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G735=\"\",\"\",[1]Application!$G735),IF([1]Application!$G712=\"\",\"\",[1]Application!$G712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K735=\"\",\"\",[1]Application!$K735),IF([1]Application!$K712=\"\",\"\",[1]Application!$K712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O735=\"\",\"\",[1]Application!$O735),IF([1]Application!$O712=\"\",\"\",[1]Application!$O712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T735=\"\",\"\",[1]Application!$T735),IF([1]Application!$Y712=\"\",\"\",[1]Application!$Y712))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC735,[1]Application!$AH712)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesResUnitDemolition",{"$f":"IF(CreditType=4,AND([1]Application!$AJ$355=\"Yes\",[1]Application!$AJ$356>0),AND([1]Application!$AJ$349=\"Yes\",[1]Application!$AJ$350>0))","v":false},"Demolition of existing residential units",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B736=\"\",\"\",[1]Application!$B736),IF([1]Application!$B713=\"\",\"\",[1]Application!$B713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G736=\"\",\"\",[1]Application!$G736),IF([1]Application!$G713=\"\",\"\",[1]Application!$G713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K736=\"\",\"\",[1]Application!$K736),IF([1]Application!$K713=\"\",\"\",[1]Application!$K713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O736=\"\",\"\",[1]Application!$O736),IF([1]Application!$O713=\"\",\"\",[1]Application!$O713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T736=\"\",\"\",[1]Application!$T736),IF([1]Application!$Y713=\"\",\"\",[1]Application!$Y713))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC736,[1]Application!$AH713)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesTenantRelocation",{"$f":"IF(CreditType=4,[1]Application!$AJ$357=\"Yes\",[1]Application!$AJ$351=\"Yes\")","v":false},"Relocation of existing residential tenants",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B737=\"\",\"\",[1]Application!$B737),IF([1]Application!$B714=\"\",\"\",[1]Application!$B714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G737=\"\",\"\",[1]Application!$G737),IF([1]Application!$G714=\"\",\"\",[1]Application!$G714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K737=\"\",\"\",[1]Application!$K737),IF([1]Application!$K714=\"\",\"\",[1]Application!$K714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O737=\"\",\"\",[1]Application!$O737),IF([1]Application!$O714=\"\",\"\",[1]Application!$O714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T737=\"\",\"\",[1]Application!$T737),IF([1]Application!$Y714=\"\",\"\",[1]Application!$Y714))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC737,[1]Application!$AH714)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesRehabilitation",{"$f":"IF(CreditType=4,OR([1]Application!$M$358=\"Yes\",[1]Application!$M$357=\"Yes\"),OR([1]Application!$M$351=\"Yes\",[1]Application!$M$352=\"Yes\"))","v":true},"Rehab of existing residential buildings",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B738=\"\",\"\",[1]Application!$B738),IF([1]Application!$B715=\"\",\"\",[1]Application!$B715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G738=\"\",\"\",[1]Application!$G738),IF([1]Application!$G715=\"\",\"\",[1]Application!$G715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K738=\"\",\"\",[1]Application!$K738),IF([1]Application!$K715=\"\",\"\",[1]Application!$K715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O738=\"\",\"\",[1]Application!$O738),IF([1]Application!$O715=\"\",\"\",[1]Application!$O715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T738=\"\",\"\",[1]Application!$T738),IF([1]Application!$Y715=\"\",\"\",[1]Application!$Y715))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC738,[1]Application!$AH715)","v":0},null,null,null,"","","",null,"","",""]
["g_Resyndication",{"$f":"IF(CreditType=4,[1]Application!$X$180=\"Yes\",[1]Application!$Y$180=\"Yes\")","v":false},"Resyndication",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B739=\"\",\"\",[1]Application!$B739),IF([1]Application!$B716=\"\",\"\",[1]Application!$B716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G739=\"\",\"\",[1]Application!$G739),IF([1]Application!$G716=\"\",\"\",[1]Application!$G716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K739=\"\",\"\",[1]Application!$K739),IF([1]Application!$K716=\"\",\"\",[1]Application!$K716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O739=\"\",\"\",[1]Application!$O739),IF([1]Application!$O716=\"\",\"\",[1]Application!$O716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T739=\"\",\"\",[1]Application!$T739),IF([1]Application!$Y716=\"\",\"\",[1]Application!$Y716))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC739,[1]Application!$AH716)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesHomeOwnership",null,"Eventual home ownership",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B740=\"\",\"\",[1]Application!$B740),IF([1]Application!$B717=\"\",\"\",[1]Application!$B717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G740=\"\",\"\",[1]Application!$G740),IF([1]Application!$G717=\"\",\"\",[1]Application!$G717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K740=\"\",\"\",[1]Application!$K740),IF([1]Application!$K717=\"\",\"\",[1]Application!$K717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O740=\"\",\"\",[1]Application!$O740),IF([1]Application!$O717=\"\",\"\",[1]Application!$O717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T740=\"\",\"\",[1]Application!$T740),IF([1]Application!$Y717=\"\",\"\",[1]Application!$Y717))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC740,[1]Application!$AH717)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesElevators",{"$f":"IF(CreditType=4,[1]Application!$R$411=\"Yes\",[1]Application!$R$404=\"Yes\")","v":false},"Elevators",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B741=\"\",\"\",[1]Application!$B741),IF([1]Application!$B718=\"\",\"\",[1]Application!$B718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G741=\"\",\"\",[1]Application!$G741),IF([1]Application!$G718=\"\",\"\",[1]Application!$G718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K741=\"\",\"\",[1]Application!$K741),IF([1]Application!$K718=\"\",\"\",[1]Application!$K718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O741=\"\",\"\",[1]Application!$O741),IF([1]Application!$O718=\"\",\"\",[1]Application!$O718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T741=\"\",\"\",[1]Application!$T741),IF([1]Application!$Y718=\"\",\"\",[1]Application!$Y718))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC741,[1]Application!$AH718)","v":0},null,null,null,"","","",null,"","",""]
["g_OnTribalTrustLand",null,"Tribal trust land",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B742=\"\",\"\",[1]Application!$B742),IF([1]Application!$B719=\"\",\"\",[1]Application!$B719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G742=\"\",\"\",[1]Application!$G742),IF([1]Application!$G719=\"\",\"\",[1]Application!$G719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K742=\"\",\"\",[1]Application!$K742),IF([1]Application!$K719=\"\",\"\",[1]Application!$K719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O742=\"\",\"\",[1]Application!$O742),IF([1]Application!$O719=\"\",\"\",[1]Application!$O719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T742=\"\",\"\",[1]Application!$T742),IF([1]Application!$Y719=\"\",\"\",[1]Application!$Y719))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC742,[1]Application!$AH719)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesCommercial",null,"Commercial space",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B743=\"\",\"\",[1]Application!$B743),IF([1]Application!$B720=\"\",\"\",[1]Application!$B720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G743=\"\",\"\",[1]Application!$G743),IF([1]Application!$G720=\"\",\"\",[1]Application!$G720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K743=\"\",\"\",[1]Application!$K743),IF([1]Application!$K720=\"\",\"\",[1]Application!$K720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O743=\"\",\"\",[1]Application!$O743),IF([1]Application!$O720=\"\",\"\",[1]Application!$O720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T743=\"\",\"\",[1]Application!$T743),IF([1]Application!$Y720=\"\",\"\",[1]Application!$Y720))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC743,[1]Application!$AH720)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesCommunityServiceFacilities",null,"Community Service Facilities",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B744=\"\",\"\",[1]Application!$B744),IF([1]Application!$B721=\"\",\"\",[1]Application!$B721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G744=\"\",\"\",[1]Application!$G744),IF([1]Application!$G721=\"\",\"\",[1]Application!$G721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K744=\"\",\"\",[1]Application!$K744),IF([1]Application!$K721=\"\",\"\",[1]Application!$K721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O744=\"\",\"\",[1]Application!$O744),IF([1]Application!$O721=\"\",\"\",[1]Application!$O721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T744=\"\",\"\",[1]Application!$T744),IF([1]Application!$Y721=\"\",\"\",[1]Application!$Y721))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC744,[1]Application!$AH721)","v":0},null,null,null,"","","",null,"","",""]
["g_PartOfSimultaneousPhases",null,"Multiple simultaneous phases",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B745=\"\",\"\",[1]Application!$B745),IF([1]Application!$B722=\"\",\"\",[1]Application!$B722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G745=\"\",\"\",[1]Application!$G745),IF([1]Application!$G722=\"\",\"\",[1]Application!$G722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K745=\"\",\"\",[1]Application!$K745),IF([1]Application!$K722=\"\",\"\",[1]Application!$K722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O745=\"\",\"\",[1]Application!$O745),IF([1]Application!$O722=\"\",\"\",[1]Application!$O722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T745=\"\",\"\",[1]Application!$T745),IF([1]Application!$Y722=\"\",\"\",[1]Application!$Y722))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC745,[1]Application!$AH722)","v":0},null,null,null,"","","",null,"","",""]
["g_FulfillsInclusionaryReq",null,"Fulfills inclusionary requirements",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B746=\"\",\"\",[1]Application!$B746),IF([1]Application!$B723=\"\",\"\",[1]Application!$B723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G746=\"\",\"\",[1]Application!$G746),IF([1]Application!$G723=\"\",\"\",[1]Application!$G723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K746=\"\",\"\",[1]Application!$K746),IF([1]Application!$K723=\"\",\"\",[1]Application!$K723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O746=\"\",\"\",[1]Application!$O746),IF([1]Application!$O723=\"\",\"\",[1]Application!$O723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T746=\"\",\"\",[1]Application!$T746),IF([1]Application!$Y723=\"\",\"\",[1]Application!$Y723))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC746,[1]Application!$AH723)","v":0},null,null,null,"","","",null,"","",""]
["g_IsHybrid",null,"Multiple simultaneous phase with differing credit types",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B747=\"\",\"\",[1]Application!$B747),IF([1]Application!$B724=\"\",\"\",[1]Application!$B724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G747=\"\",\"\",[1]Application!$G747),IF([1]Application!$G724=\"\",\"\",[1]Application!$G724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K747=\"\",\"\",[1]Application!$K747),IF([1]Application!$K724=\"\",\"\",[1]Application!$K724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O747=\"\",\"\",[1]Application!$O747),IF([1]Application!$O724=\"\",\"\",[1]Application!$O724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T747=\"\",\"\",[1]Application!$T747),IF([1]Application!$Y724=\"\",\"\",[1]Application!$Y724))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC747,[1]Application!$AH724)","v":0},null,null,null,"","","",null,"","",""]
["g_Historical",null,"Includes an historical building",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B748=\"\",\"\",[1]Application!$B748),IF([1]Application!$B725=\"\",\"\",[1]Application!$B725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G748=\"\",\"\",[1]Application!$G748),IF([1]Application!$G725=\"\",\"\",[1]Application!$G725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K748=\"\",\"\",[1]Application!$K748),IF([1]Application!$K725=\"\",\"\",[1]Application!$K725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O748=\"\",\"\",[1]Application!$O748),IF([1]Application!$O725=\"\",\"\",[1]Application!$O725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T748=\"\",\"\",[1]Application!$T748),IF([1]Application!$Y725=\"\",\"\",[1]Application!$Y725))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC748,[1]Application!$AH725)","v":0},null,null,null,"","","",null,"","",""]
[null,"Partnership Contacts",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B749=\"\",\"\",[1]Application!$B749),IF([1]Application!$B726=\"\",\"\",[1]Application!$B726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G749=\"\",\"\",[1]Application!$G749),IF([1]Application!$G726=\"\",\"\",[1]Application!$G726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K749=\"\",\"\",[1]Application!$K749),IF([1]Application!$K726=\"\",\"\",[1]Application!$K726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O749=\"\",\"\",[1]Application!$O749),IF([1]Application!$O726=\"\",\"\",[1]Application!$O726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T749=\"\",\"\",[1]Application!$T749),IF([1]Application!$Y726=\"\",\"\",[1]Application!$Y726))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC749,[1]Application!$AH726)","v":0},null,null,null,"","","",null,"","",""]
["g_EventualOwnershipEntity",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B750=\"\",\"\",[1]Application!$B750),IF([1]Application!$B727=\"\",\"\",[1]Application!$B727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G750=\"\",\"\",[1]Application!$G750),IF([1]Application!$G727=\"\",\"\",[1]Application!$G727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K750=\"\",\"\",[1]Application!$K750),IF([1]Application!$K727=\"\",\"\",[1]Application!$K727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O750=\"\",\"\",[1]Application!$O750),IF([1]Application!$O727=\"\",\"\",[1]Application!$O727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T750=\"\",\"\",[1]Application!$T750),IF([1]Application!$Y727=\"\",\"\",[1]Application!$Y727))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC750,[1]Application!$AH727)","v":0},null,null,null,"","","",null,"","",""]
["g_TcacApplicant",{"$f":"IF(CreditType=4,[1]Application!$H$16,[1]Application!$H$15)","v":"304 E. Spruce St, LP"},"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B751=\"\",\"\",[1]Application!$B751),IF([1]Application!$B728=\"\",\"\",[1]Application!$B728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G751=\"\",\"\",[1]Application!$G751),IF([1]Application!$G728=\"\",\"\",[1]Application!$G728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K751=\"\",\"\",[1]Application!$K751),IF([1]Application!$K728=\"\",\"\",[1]Application!$K728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O751=\"\",\"\",[1]Application!$O751),IF([1]Application!$O728=\"\",\"\",[1]Application!$O728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T751=\"\",\"\",[1]Application!$T751),IF([1]Application!$Y728=\"\",\"\",[1]Application!$Y728))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC751,[1]Application!$AH728)","v":0},null,null,null,"","","",null,"","",""]
["g_LeadDeveloper",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B752=\"\",\"\",[1]Application!$B752),IF([1]Application!$B729=\"\",\"\",[1]Application!$B729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G752=\"\",\"\",[1]Application!$G752),IF([1]Application!$G729=\"\",\"\",[1]Application!$G729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K752=\"\",\"\",[1]Application!$K752),IF([1]Application!$K729=\"\",\"\",[1]Application!$K729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O752=\"\",\"\",[1]Application!$O752),IF([1]Application!$O729=\"\",\"\",[1]Application!$O729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T752=\"\",\"\",[1]Application!$T752),IF([1]Application!$Y729=\"\",\"\",[1]Application!$Y729))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC752,[1]Application!$AH729)","v":0},null,null,null,"","","",null,"","",""]
["g_ManagingGeneralPartner",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J787=\"\",\"\",[1]Application!$J787),IF([1]Application!$J766=\"\",\"\",[1]Application!$J766))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O787=\"\",\"\",[1]Application!$O787),IF([1]Application!$O766=\"\",\"\",[1]Application!$O766))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T787=\"\",\"\",[1]Application!$T787),IF([1]Application!$T766=\"\",\"\",[1]Application!$T766))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X787=\"\",\"\",[1]Application!$X787),IF([1]Application!$X766=\"\",\"\",[1]Application!$X766))","v":""},null,null,0,true,null,{"$f":"SUM(O3:O36)","v":0},{"$f":"SUM(P3:P36)","v":0},{"$f":"SUM(Q3:Q36)","v":0},null,{"$f":"SUM(S3:S36)","v":59},{"$f":"SUM(T3:T36)","v":1},{"$f":"SUM(U3:U36)","v":0.49152542372881358}]
["g_AdministrativeGeneralPartner",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J788=\"\",\"\",[1]Application!$J788),IF([1]Application!$J767=\"\",\"\",[1]Application!$J767))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O788=\"\",\"\",[1]Application!$O788),IF([1]Application!$O767=\"\",\"\",[1]Application!$O767))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T788=\"\",\"\",[1]Application!$T788),IF([1]Application!$T767=\"\",\"\",[1]Application!$T767))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X788=\"\",\"\",[1]Application!$X788),IF([1]Application!$X767=\"\",\"\",[1]Application!$X767))","v":""},null,null,0,true]
["g_ProjectSponsor",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J789=\"\",\"\",[1]Application!$J789),IF([1]Application!$J768=\"\",\"\",[1]Application!$J768))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O789=\"\",\"\",[1]Application!$O789),IF([1]Application!$O768=\"\",\"\",[1]Application!$O768))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T789=\"\",\"\",[1]Application!$T789),IF([1]Application!$T768=\"\",\"\",[1]Application!$T768))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X789=\"\",\"\",[1]Application!$X789),IF([1]Application!$X768=\"\",\"\",[1]Application!$X768))","v":""},null,null,0,true]
["g_PrimaryContact",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J790=\"\",\"\",[1]Application!$J790),IF([1]Application!$J769=\"\",\"\",[1]Application!$J769))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O790=\"\",\"\",[1]Application!$O790),IF([1]Application!$O769=\"\",\"\",[1]Application!$O769))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T790=\"\",\"\",[1]Application!$T790),IF([1]Application!$T769=\"\",\"\",[1]Application!$T769))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X790=\"\",\"\",[1]Application!$X790),IF([1]Application!$X769=\"\",\"\",[1]Application!$X769))","v":""},null,null,0,true]
[null,"Sources Information",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J791=\"\",\"\",[1]Application!$J791),IF([1]Application!$J770=\"\",\"\",[1]Application!$J770))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O791=\"\",\"\",[1]Application!$O791),IF([1]Application!$O770=\"\",\"\",[1]Application!$O770))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T791=\"\",\"\",[1]Application!$T791),IF([1]Application!$T770=\"\",\"\",[1]Application!$T770))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X791=\"\",\"\",[1]Application!$X791),IF([1]Application!$X770=\"\",\"\",[1]Application!$X770))","v":""},null,null,0,true]
["g_SourcesPermanent",null,"Sum of Sources[PermAmount] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J792=\"\",\"\",[1]Application!$J792),IF([1]Application!$J771=\"\",\"\",[1]Application!$J771))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O792=\"\",\"\",[1]Application!$O792),IF([1]Application!$O771=\"\",\"\",[1]Application!$O771))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T792=\"\",\"\",[1]Application!$T792),IF([1]Application!$T771=\"\",\"\",[1]Application!$T771))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X792=\"\",\"\",[1]Application!$X792),IF([1]Application!$X771=\"\",\"\",[1]Application!$X771))","v":""},null,null,0,true]
["g_SourcesConstruction",null,"Sum of Sources[ConAmount] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J793=\"\",\"\",[1]Application!$J793),IF([1]Application!$J772=\"\",\"\",[1]Application!$J772))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O793=\"\",\"\",[1]Application!$O793),IF([1]Application!$O772=\"\",\"\",[1]Application!$O772))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T793=\"\",\"\",[1]Application!$T793),IF([1]Application!$T772=\"\",\"\",[1]Application!$T772))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X793=\"\",\"\",[1]Application!$X793),IF([1]Application!$X772=\"\",\"\",[1]Application!$X772))","v":""},null,null,0,true]
["g_SourcesDebtService",null,"Sum of Sources[DebtService] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J794=\"\",\"\",[1]Application!$J794),IF([1]Application!$J773=\"\",\"\",[1]Application!$J773))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O794=\"\",\"\",[1]Application!$O794),IF([1]Application!$O773=\"\",\"\",[1]Application!$O773))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T794=\"\",\"\",[1]Application!$T794),IF([1]Application!$T773=\"\",\"\",[1]Application!$T773))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X794=\"\",\"\",[1]Application!$X794),IF([1]Application!$X773=\"\",\"\",[1]Application!$X773))","v":""},null,null,0,true]
["g_TaxExemptFinPerm",null,"Sum of perm sources labeled Tax-Exempt Loan",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J795=\"\",\"\",[1]Application!$J795),IF([1]Application!$J774=\"\",\"\",[1]Application!$J774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O795=\"\",\"\",[1]Application!$O795),IF([1]Application!$O774=\"\",\"\",[1]Application!$O774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T795=\"\",\"\",[1]Application!$T795),IF([1]Application!$T774=\"\",\"\",[1]Application!$T774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X795=\"\",\"\",[1]Application!$X795),IF([1]Application!$X774=\"\",\"\",[1]Application!$X774))","v":""},null,null,0,true]
["g_TaxExemptFinCon",null,"Sum of construction sources labeled Tax-Exempt Loan",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J796=\"\",\"\",[1]Application!$J796),IF([1]Application!$J775=\"\",\"\",[1]Application!$J775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O796=\"\",\"\",[1]Application!$O796),IF([1]Application!$O775=\"\",\"\",[1]Application!$O775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T796=\"\",\"\",[1]Application!$T796),IF([1]Application!$T775=\"\",\"\",[1]Application!$T775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X796=\"\",\"\",[1]Application!$X796),IF([1]Application!$X775=\"\",\"\",[1]Application!$X775))","v":""},null,null,0,true]
["g_SourcesCommittedPerm",null,"Sum of committed permanent financing",null,null,0,{"$f":"[1]Application!$O$786","v":0},0,0,0,0,0]
["g_SourcesCommittedCon",null,"Sum of committed construction period financing"]
[null,"Cost Information"]
["g_TotalProjectCost",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$B$105,'[1]Sources and Uses Budget'!$B$104)","v":46698498},"Sum of Uses[Use] individually rounded down, excluding headings"]
["g_TotalResidentialCost",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$C$105,'[1]Sources and Uses Budget'!$C$104)","v":46698498},"Total Residential Project Cost from S&U"]
["g_LandCost",{"$f":"'[1]Sources and Uses Budget'!$B$4","v":2000000},"Land Cost from Sources and Uses Budget"]
["g_HoldingCost",{"$f":"'[1]Sources and Uses Budget'!$B$13","v":125000},"Holding Cost from Sources and Uses Budget"]
["g_ImprovementsValue",{"$f":"'[1]Sources and Uses Budget'!$B$9","v":4200000},"Existing Improvements Value from Sources and Uses Budget"]
["g_CostRehab",{"$f":"SUM('[1]Sources and Uses Budget'!$C$17,'[1]Sources and Uses Budget'!$C$18,'[1]Sources and Uses Budget'!$C$22)","v":0},"Site, Structures, and Prevailing Wage for Rehabilitation from S&U Budget"]
["g_BasisEligible",null,"Sum of Uses[EligibleBasis] individually rounded down, excluding headings"]
["g_BasisAcquisition",null,"Sum of Uses[Acquisition Basis] individually rounded down, excluding headings"]
["g_CostCommercial",null,"Sum of Uses[Commercial Portion] individually rounded down, excluding headings"]
["g_CostCommunityService",null,"Sum of Uses[CSF Portion] individually rounded down, excluding headings"]
["g_CostResidential",null,"TotalProjectCost minus CostCommercial and CostCommunityService"]
["g_CapitalizedOperatingReserve",null,"Capitalized Operating Reserve from Uses table"]
["g_StatePrevailingWages",null,"Paying state prevailing wages"]
["g_FederalDavisBaconActWages",null,"Paying federal Davis Bacon Act wages"]
["g_TotalServicesBudget",{"$f":"'[1]15 Year Pro Forma'!$E$27","v":25000},"Year 1 Services Cost from 15 Year Pro Forma"]
[null,"Square Footage Information"]
["g_SqFtTotal",null,"Total of all square footages"]
["g_SqFtResidential",null,"Sumproduce of Quantity and Square Feet in UnitsTbl"]
["g_SqFtLowIncome",null,"Includes only units with Gen AMI <= 80%"]
["g_SqFtExemptUnits",null,"Includes only units with Exempt Unit = TRUE"]
["g_SqFtCommon",null,"Exempt common area square footage"]
["g_SqFtCommunity",null,"Exempt community area square footage"]
["g_SqFtStructuredParking",null,"Structured parking square footage"]
["g_SqFtCommercial",null,"Commercial space square footage"]
["g_SqFtCommunityService",null,"Community service facility square footage"]
["g_SqFtSite",null,"Site size in acres * 43560"]
[null,"Unit Information"]
["g_UnitsRental",{"$f":"IF(CreditType=4,[1]Application!$AG$439,[1]Application!$AG$432)","v":59},"total number of units excluding managers units"]
["g_UnitsTotal",{"$f":"IF(CreditType=4,[1]Application!$AG$437,[1]Application!$AG$430)","v":60},"total of all units - low income, manager, and market-rate"]
["g_UnitsTaxCredit",{"$f":"IF(CreditType=4,[1]Application!$G$753+[1]Application!$O$777,[1]Application!$G$730+[1]Application!$O$756)","v":60},"UnitsLowIncome plus UnitsExempt"]
["g_UnitsNonTaxCredit",{"$f":"IF(CreditType=4,[1]Application!$O$797,[1]Application!$O$776)","v":0},"UnitsResidential minus UnitsTaxCredit ( market rate)"]
["g_UnitsExempt",{"$f":"IF(CreditType=4,[1]Application!$O$777,[1]Application!$O$756)","v":1},"Sum of Exempt Units (manager units)"]
["g_UnitsSubsidized",null,"Sum of Residential Unit with Contract Rent"]
["g_UnitsLowIncome",{"$f":"IF(CreditType=4,[1]Application!$G$753,[1]Application!$G$730)","v":59},"Sum of Res. Units at/below 80% AMI",null,{"$f":"IF(CreditType=4,[1]Application!$Y$211,ROUNDUP(([1]Application!$AE$215*[1]Application!$AG$433),0))","v":0}]
["g_UnitsSpecialNeeds",{"$f":"SUM(UnitsTbl[Count SpN Units])","v":0},"Sum of Special Needs units"]
["g_UnitsSpecialNeedsEapp",{"$f":"IF(CreditType=4,[1]Application!$Y$212,[1]Application!$AC$215)","v":0},"Count of SpN units entered by applicant in e-app"]
["g_UnitsPsh",null,"Sum of Permanent Supportive Housing Units"]
["g_UnitsHomeless",{"$f":"IF(CreditType=4,[1]Application!$W$465,[1]Application!$W$458)","v":0},"Sum of Homeless Housing Units"]
["g_UnitsHomeOwnership",null,"Sum of Home Ownership units"]
["g_UnitsAgeRestricted",null,"Sum of Age Restricted units"]
["g_AmiAvgLowIncomeUnits",null,"Sum of Rental AMIs under 80% divided by UnitsLowIncome"]
["g_UnitsDemolished",null,"Count of existing units to be demolished"]
["g_UnitsRetained",null,"Count of existing units to be retained"]
["g_Units0",null,"Count all low-income studio units"]
["g_Units1",null,"Count all low-income 1-BR units"]
["g_Units2",null,"Count all low-income 2-BR units"]
["g_Units3",null,"Count all low-income 3-BR units"]
["g_Units4",null,"Count all low-income 4-BR units"]
["g_Units5",null,"Count all low-income 5-BR units"]
["g_SpNe0",null,"Count of Special Needs studio units"]
["g_SpNe1",null,"Count of Special Needs 1-BR units"]
["g_SpNe2",null,"Count of Special Needs 2-BR units"]
["g_SpNe3",null,"Count of Special Needs 3-BR units"]
["g_SpNe4",null,"Count of Special Needs 4-BR units"]
["g_SpNe5",null,"Count of Special Needs 5-BR units"]
["g_MktUnits0",null,"Count of Market Rate studio units"]
["g_MktUnits1",null,"Count of Market Rate 1-BR units"]
["g_MktUnits2",null,"Count of Market Rate 2-BR units"]
["g_MktUnits3",null,"Count of Market Rate 3-BR units"]
["g_MktUnits4",null,"Count of Market Rate 4-BR units"]
["g_MktUnits5",null,"Count of Market Rate 5-BR units"]
[null,"Product Information"]
["g_BuildingsResidential",null,"Quantity of residential buildings in the project"]
["g_BuildingsNonResidential",null,"Quantity of non-residential buildings in the project"]
["g_BuildingStories",{"$f":"IF(CreditType=4,IF(AND([1]Application!$AD$411>0,[1]Application!$AD$412>0),MAX([1]Application!$AD$411,[1]Application!$AD$412),IF([1]Application!$AD$411>0,[1]Application!$AD$411,IF([1]Application!$AD$412>0,[1]Application!$AD$412,1))),IF(AND([1]Application!$AD$404>0,[1]Application!$AD$405>0),MAX([1]Application!$AD$404,[1]Application!$AD$405),IF([1]Application!$AD$404>0,[1]Application!$AD$404,IF([1]Application!$AD$405>0,[1]Application!$AD$405,1))))","v":2},"Number of stories in buildings"]
["g_ParkingCount",null,"Parking spaces provided on site"]
["g_BedroomsTotal",{"$f":"SUM(((B93+B105)*1),((B94+B106)*1),((B95+B107)*2),((B96+B108)*3),((B97+B109)*4),((B98+B110)*5))","v":0},"Sum of unit bedrooms counting 1 per studio"]
["g_BedroomsSpecialNeeds",{"$f":"SUM((B99*1),(B100*1),(B101*2),(B102*3),(B103*4),(B104*5))","v":0},"Same calculation as above but requiring Special Needs designation"]
["g_LaundryWashersCount",null,"Community washing machines available for tenant use"]
["g_LaundryDryersCount",null,"Community clothes dryers available fore tenant use"]
["g_eAppBedroomsSpN",{"$f":"IF(CreditType=4,[1]Application!$AG$756,[1]Application!$AG$733)","v":0},"Number of Special Needs bedrooms listed in e-app"]
[null,"Cash Flow Information"]
["g_ResidentialIncomeMonthly",null,"Monthly residential rental income"]
["g_ContractRentIncomeMonthly",null,"Monthly rental subsidy income"]
["g_GrossPotentialIncome",null,"All income, excluding in-kind services, projected in Year 1"]
["g_TotalAnnualIncome",null,"All income projected in Year 1 after vacancy"]
["g_TotalAnnualExpenses",null,"Sum of Annual Expenses from ExpenseTbl"]
["g_AnnExpensesForTcacMin",null,"Sum of Annual Expenses that qualify towards TCAC minimum expenses"]
["g_AnnualReplacementReserves",null,"Annual Replacement Reserve funding from Expenese table"]
["g_AnnRepResPerUnit",null,"Annual Replacement Reserve per unit"]
["g_NetOperatingIncome",null,"Net Operating Income in Year 1"]
["g_TotalDebtService",null,"Total debt service in Year 1"]
["g_Lowest15YearCashFlow",null,"Minimum of first 15 years of cash flow after debt service"]
[null,"County Data"]
["tcd_RentLimits",null,"Year rent limits were published"]
["tcd_BasisLimits9",null,"Year basis limits were published"]
["tcd_BasisLimits4",null,"Year basis limits were published"]
["tcd_MinAnExp",null,"Year minimum operating expenses were published"]
["tcd_Version",null,"The version number for this file"]
[null,"Tax Credits"]
["t_FederalCreditsAnnual",null,"Maximum allowed Federal tax credits"]
["t_StateCreditsTotal",null,"Maximum allowed State tax credits"]
[null,"Developer Fee"]
["t_DeveloperFeeLimit",null,"Overall limit on developer fee"]
["t_MinDevFeeDeferral",null,"Minimum required deferral/contribution of developer fee"]
["t_DeveloperFeeLimitCapitalized",null,"Maximum allowable developer fee payments from sources"]
["t_TotalDeveloperFee",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$B$104,'[1]Sources and Uses Budget'!$B$103)","v":8260700},"Total sum of all Developer fee"]
[null,"Threshold Basis Limits"]
["t_ThresholdBasisLimit"]
["t_UnAdjustedThresholdBasisLimit"]
["t_TblDeeperTargetingBoosts"]
[null,"Compliance"]
["t_HighCostPercentage"]
["t_ApplicableFraction"]
["t_TaxCreditUnits"]
["t_LowIncomeUnits"]
["t_MinOperatingExpenses"]
[null,"Application Characteristics"]
["t_CreditType",{"$f":"[1]Application!$AS$1","v":4}]
["t_SubmittalType"]
["t_IsBipocJv"]
["t_Is4percent"]
["t_Is9percent"]
["t_IsResyndication",{"$f":"IF(CreditType=4,[1]Application!$X$180=\"Yes\",[1]Application!$Y$180=\"Yes\")","v":false}]
["t_ResyndOriginalNumber1",{"$f":"IF(CreditType=4,CONCATENATE(\"CA-\",[1]Application!$S$377,\"-\",[1]Application!$V$377),CONCATENATE(\"CA-\",[1]Application!$S$370,\"-\",[1]Application!$V$370))","v":"CA-N/A-N/A"}]
["t_ResyndOriginalNumber2",{"$f":"IF(CreditType=4,CONCATENATE(\"CA-\",[1]Application!$AD$377,\"-\",[1]Application!$AG$377),CONCATENATE(\"CA-\",[1]Application!$AD$370,\"-\",[1]Application!$AG$370))","v":"CA-N/A-N/A"}]
["t_Is9snBothBoost"]
["t_IsLowValueRehab"]
["t_IsFarmworker"]
["t_Isg1B"]
["t_Isg1A"]
["t_IsNewConstruction",{"$f":"IF(CreditType=4,[1]Application!$M355=\"Yes\",[1]Application!$M349=\"Yes\")","v":true}]
["t_IsAdaptiveReuse",{"$f":"IF(CreditType=4,[1]Application!$M356=\"Yes\",[1]Application!$M350=\"Yes\")","v":false}]
["t_IsRehabOnly",{"$f":"IF(CreditType=4,[1]Application!$M357=\"Yes\",[1]Application!$M351=\"Yes\")","v":false}]
["t_IsAcqAndRehab",{"$f":"IF(CreditType=4,[1]Application!$M358=\"Yes\",[1]Application!$M352=\"Yes\")","v":true}]
["t_IsBoosted"]
["t_IsBoostedPartial"]
["t_StateCreditType"]
["t_FederalCreditElection"]
["t_MaximumElectionAMI"]
["t_HousingType",{"$f":"IF(CreditType=4,[1]Application!$D$211,[1]Application!$D$214)","v":"SRO"}]
["t_RequiresSecondaryHousingType",{"$f":"IF(CreditType=4,AND(B180=\"Special Needs\",[1]Application!$AB$212<75%),AND(B180=\"Special Needs\",([1]Application!$AF$215<75%)))","v":false}]
["t_SecondaryHousingType",{"$f":"IF(CreditType=4,[1]Application!$D$214,[1]Application!$E$217)","v":"N/A"}]
["t_SpecialNeedsPercentage",{"$f":"IF(CreditType=4,[1]Application!$AB$212,[1]Application!$AF$215)","v":0}]
["t_AppStage"]
["t_FederalCreditFactor",{"$f":"IF(CreditType=4,'[1]Basis & Credits'!$AB$50,'[1]Basis & Credits'!$AB$49)","v":0.98}]
["t_StateCreditFactor",{"$f":"IF(CreditType=4,'[1]Basis & Credits'!$AB$71,'[1]Basis & Credits'!$AB$70)","v":0.9}]
[null,"Points Info"]
["t_HasServiceCoordinator",{"$f":"IF(CreditType=4,OR('[1]Points System'!$C$370=\"Yes\",'[1]Points System'!$C$431=\"Yes\"),OR('[1]Points System'!$C$379=\"Yes\",'[1]Points System'!$C$444=\"Yes\"))","v":true}]
["t_HasCaseManager",{"$f":"IF(CreditType=4,'[1]Points System'!$C$419=\"Yes\",'[1]Points System'!$C$432=\"Yes\")","v":false}]
["t_HasOtherServiceSpecialist",{"$f":"IF(CreditType=4,OR('[1]Points System'!$C$378=\"Yes\",'[1]Points System'!$C$431=\"Yes\"),OR('[1]Points System'!$C$444=\"Yes\",'[1]Points System'!$C$389=\"Yes\"))","v":true}]
["t_PointsAddlHousingType",{"$f":"IF(CreditType=4,OR('[1]Points System'!$B$13=\"Yes\",'[1]Points System'!$B$177=\"Large Family\",'[1]Points System'!$B$177=\"Special Needs\",'[1]Points System'!$B$177=\"Senior\",'[1]Points System'!$B$177=\"SRO\"),'[1]Points System'!$AK$68>0)","v":true}]
[]
["t_AvgAMITarget",{"$f":"IF(CreditType=4,[1]Application!$AH$752,[1]Application!$AH$730)","v":""}]

{"sheet":"Lists","index":15,"n_rows":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Don't delete or insert columns or rows",null,null,null,null,null,"ü","IsTrue",null,null,null,"M",{"$f":"ROW(#REF!)","v":{"$error":"#REF!"}},{"$f":"ROW(#REF!)","v":{"$error":"#REF!"}},null,null,null,"ProviderContacts",null,null,null,null,null,null,null,null,null,"ListProviders",null,"ListReferences",null,"GPs","Parent Co","ParentOrNA","LSQoptions","Type",null,"ListManagementCo",null,null,null,"SC1Parcels","SC2Parcels","SC3Parcels","SC4Parcels","SC5Parcels"]
[null,null,null,null,null,null,"û","IsFalse","Row Starts",null,null,1,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L2&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L2&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,"Company Name","Contact","Title","Email","Phone","Provider","R-Provider","Reference","R-Reference",null,null,null,null,null,{"$f":"IF(CreditType=4,[1]Application!$M$243,[1]Application!$M$245)","v":"304 E Spruce St. LLC"},{"$f":"IF(CreditType=4,[1]Application!$AA$249,[1]Application!$AA$251)","v":"N/A"},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"N/A"},{"$f":"IF(CreditType=4,[1]Application!$M$243,[1]Application!$M$245)","v":"304 E Spruce St. LLC"},"General Partner",null,{"$f":"IF(CreditType=4,[1]Application!$AA$335,[1]Application!$AA$329)","v":"Barker Management, Inc."}]
[null,null,null,null,null,null,null,null,"Column",null,null,2,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L3&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L3&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(1:1),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(1:1),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"IF(CreditType=4,[1]Application!$M$251,[1]Application!$M$253)","v":"Central Valley Coalition for Affordable Housing"},{"$f":"IF(CreditType=4,[1]Application!$AA$257,[1]Application!$AA$259)","v":"N/A"},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"N/A"},{"$f":"IF(CreditType=4,[1]Application!$M$251,[1]Application!$M$253)","v":"Central Valley Coalition for Affordable Housing"},"General Partner",null,{"$f":"IF(CreditType=4,IF([1]Application!$P$343=\"\",\"\",[1]Application!$P$343),IF([1]Application!$AA$337=\"\",\"\",[1]Application!$AA$337))","v":"N/A"}]
[null,null,null,null,null,null,null,"YesNoNa",null,null,null,3,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L4&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L4&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(2:2),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(2:2),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"IF(CreditType=4,[1]Application!$M$259,[1]Application!$M$261)","v":"N/A"},{"$f":"IF(CreditType=4,[1]Application!$AA$265,[1]Application!$AA$267)","v":"N/A"},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"N/A"},{"$f":"IF(CreditType=4,[1]Application!$M$259,[1]Application!$M$261)","v":"N/A"},"General Partner"]
[null,null,null,null,null,null,null,"Yes",null,null,null,4,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L5&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L5&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(3:3),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(3:3),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"_xlfn.CONCAT(IF(CreditType=4,[1]Application!$H$287,[1]Application!$H$289)&\"- Tribal Applicants Only\")","v":"BMB Housing LLC- Tribal Applicants Only"},null,{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"N/A - Developer Entity\",GeneralPartners[[#This Row],[Parent Co]])","v":"N/A - Developer Entity"},{"$f":"IF(CreditType=4,[1]Application!$H$287,[1]Application!$H$289)","v":"BMB Housing LLC"},"Developer"]
[null,null,null,null,null,null,null,"No",null,null,null,5,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L6&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L6&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(4:4),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(4:4),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_TCACApplicant\",ref,0))","v":"304 E. Spruce St, LP"},"Applicant"]
[null,null,null,null,null,null,null,"NA",null,null,null,"SiteControlTotalCost",{"$f":"SUM(M2:M6)","v":0},{"$f":"SUM(N2:N6)","v":0},"HoldingTotalCost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(5:5),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(5:5),ProviderContactsTbl[R-Reference],0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(6:6),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(6:6),ProviderContactsTbl[R-Reference],0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"ListAgreementTypes","ListAppraisalRequired"]
[null,null,null,null,null,null,null,"Grant Deed",false]
[null,null,null,null,null,null,null,"Lease Agreement",true]
[null,null,null,null,null,null,null,"Purchase and Sales Agreement",false]
[null,null,null,null,null,null,null,"Purchase Option Agreement",false]
[null,null,null,null,null,null,null,"Lease Option",true]
[null,null,null,null,null,null,null,"Disposition and Development Agreement",true]
[null,null,null,null,null,null,null,"Donation Agreement",true]
[]
[]
[null,null,null,null,null,null,null,"ListDocumentTypes"]
[null,null,null,null,null,null,null,"Amends"]
[null,null,null,null,null,null,null,"Assigns"]
[null,null,null,null,null,null,null,"Authorizes"]
[null,null,null,null,null,null,null,"Clarifies"]
[null,null,null,null,null,null,null,"Expounds"]
[null,null,null,null,null,null,null,"Extends"]
[null,null,null,null,null,null,null,"Restates"]
[null,null,null,null,null,null,null,"Site Control"]
[null,null,null,null,null,null,null,"Supports"]
[null,null,null,null,null,null,null,"Title Information"]
[]
[null,null,null,null,null,null,null,"ListCostDocTypes"]
[null,null,null,null,null,null,null,"Site Control Document"]
[null,null,null,null,null,null,null,"Settlement Statement"]
[null,null,null,null,null,null,null,"Appraisal"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_County\",ref,0))","v":"Los Angeles"},"County"]
[null,null,null,null,null,null,null,"CountyRow"]
[]
[null,null,null,null,null,null,null,"LowIncomeUnits"]
[null,null,null,null,null,null,null,"TotalUnits"]
[]
[null,null,null,null,null,null,null,"ListCreditType"]
[null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,0.09]